incomplete date/time fields

  • Thread starter Thread starter DP
  • Start date Start date
D

DP

Here's a weird question for Access 2002: I have some
date/time fields that every once in awhile might not have
all information - i.e., someone says that their last job
ended in August 2001, but they don't remember the exact
date. I don't want to change to a text field, since I
still do calculations on that field that require a date,
(how many years since their last job?) but how could I
enter 08/00/01 or 08/ /01 for those one or two people?

Thanks.
 
how could I
enter 08/00/01 or 08/ /01 for those one or two people?
Click to expand...

You can't.

A Date/Time field is stored internally as a Double Float number, a
count of days and fractions of a day since midnight, December 30,
1899. As such, any date/time field corresponds to one precise moment
of time.

I'd suggest storing either the first of the month or the last of the
month, whichever makes most sense for your needs.
 
Back
Top