How do you deal with missing values in a date/time field?

G

Guest

I am trying to use a default value in a date/time field that will indicate a
missing value. For example, in a text field, I could use n/a, or in a number
field 9999. I haven't been able to do anything with the date/time field
other than leave it blank, and I don't want blank fields.
Any ideas? Thanks a lot!
 
B

Brendan Reynolds

I would strongly recommend that you do leave it blank (Null). If you are
certain that you have good reason not to do that, though, consider either
the minimum or maximum possible values for a Date - 1 January 100 0:00:00
and 31 December 9999 23:59:59, respectively, in VBA and JET.

You may also want to give some thought as to whether you may ever need to
share this data with SQL Server, which has different minimum and maximum
values. (See SQL Server Books Online if you need the details.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to code a missing value in a Time field? 2
Insert Date into Field2, the first Time Field1 is Populated with Dataon Form 2
Excel How to get the number of days an item was opened from the today's date. 14
Access 2007 - Entering of datetime values in double field 1
Date/Time Error 3421 5
Using Date Parameters in a Query with Date and Time 7
Make a Date Field Autopopulate 6
Date/Time questions 13

Top