Hi,

MS SQL-Server doesn't have the concept of an empty date(time), actually i don't know a tool other than VFP that differentiates between acutal date values, empty dates, and NULL values.

In SQL Server a date either has a value like 2005-01-01 or is NULL.

Unfortunately VFP upsizes empty date values not as explicit NULL, so SQL-Server uses a default value (1900-01-01).

You can replace your empty dates with NULL, then they're stored as NULL in SQL-Server also.

In you reports you then can easily check with the ISNULL() function for empty values.

Regards
Christian