When a file from a 3rd party was used to create a SQL database, if there was a blank field in one of the date columns, SQL populated the field as 01/01/1900 (my DBA said that is how SQL works). He said he could bring them in as NULLs but I think that would be just as bad.
I'm wanting to create a calculated column where: if the Invoice_Date is 01/01/1900, then put a 0 or blank, otherwise, put the Invoice_date. I've tried using different IF statements with BLANK() and such, but just can't get it right. Is this even possible?