variations on entering a date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to account for every variation of date (complete, incomplete and
blank). The date/time fields only allow for a complete entry (ie 2/2/02)
and not (unk/unk/94). Is there a different format field I could use that
will allow me to enter in some incomplete dates?

Thanks
 
PC said:
Why do you want to enter incomplete dates?
Click to expand...

If you just want something like June or 1995 or 4/5 to stay that way you
will have to use a text field.
Access *will* store a date and time value in a date field.
 
Back
Top