Blank Date Field

[Andy]

I am using an ASP page to update/create records in
Access. Here is the problem - if I set a field to be a
Date field in the DB, (yes the # instead of ' is used in
the code...) it doesn't work if the field is left blank.
If I type in a date, it does work.

I tried setting a default value in Access, but that
didn't work either.

Help!

 

[Douglas J. Steele]

Dates are stored internally as floating point numbers, so blank isn't a
valid value for a date.

You can make sure that your date fields aren't required, and then just not
provide a value. That way, it'll be stored as Null.