Date issue sending null

Hi just wondering if anyone has come across the issue of “1900-01-01” been recorded in the date field and how it was resolved. I am using SQL Express as the backend database.

Some database servers will not allow you to enter Null for a date or datetime field so they enter 1900-01-01 or 0000-00-00 or some other date.

Once you realize your database server will not allow you to enter Null, make a note of the date that it does enter so you can use it as a filter to remove those from your queries (or add them as the case may be).

1 Like