Blank Date Field

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!

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

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!

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 28th May 20:23 andy External User Posts: 1	Blank Date Field 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!

2 28th May 20:23 douglas j. steele External User Posts: 1	Blank Date Field 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (No private e-mails, please)

3 28th May 20:24 andy External User Posts: 1	Blank Date Field 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!

4 28th May 20:24 douglas j. steele External User Posts: 1	Blank Date Field 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (No private e-mails, please)