>That's what you have to do. Most "real" databases (and Access pretends to be a "real" database) do not accept empty dates. Dates (or datetimes) have a value or they are null.
>
>If the database will not accept null, you must supply a populated date.
>
>This is one place where Foxpro data is fundamentally incompatible with every other database system. VFP is the only place where EMPTY() is a valid value for a date or datetime field.

It might be incompatible, but this approach makes the most sense. :)