Hi John !
Thanks for the interesting idea. I will look at it.

>Josef
>
>You are describing something that bites everybody who converts a VFP app for SQL server! It used to be far worse before VFP handled null in local fields.
>
>My advice is to get a tool like xcase to manage your databases. Allow NULLS for all your date and datetime fields and set a default value of NULL. Xcase will create scripts to update both your local and SQL tables so you don't have to worry about it.
>
>Regards
>
>JR