variations on entering a date?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat Dools - 10 Apr 2005 18:39 GMT

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

Signature

Pat Dools

Reply to this Message

PC Datasheet - 10 Apr 2005 21:09 GMT

Why do you want to enter incomplete dates?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> 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)
[quoted text clipped - 4 lines]
> --
> Pat Dools

Reply to this Message

Mike Painter - 10 Apr 2005 22:43 GMT

> Why do you want to enter incomplete dates?
>
>> 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?

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.

Reply to this Message