There is no empty date value in SQL Server. An empty date will show up as 1/1/1900.

You can address this by storing NULL value for empty dates - although this will bring up new issues since then you'll need to account for NULL values everywhere the data is used. You can also address it on the front end. It is very common for people to write a customized texbox class to handle SQL Server dates.


>Hi All
>
>I have an old app that I am in the process of converting to vfp8. My customer just called and says that the date for 02/28/2003 is showing up as 01/01/1900. This app is using mssql 6.5 as the back end and the date in the database is correct. Any ideas how to fix this?
>
>Thanks