Hi!!!

I work for a goverment department and look after there databases. I wish to
make it possible to input 99/99/9999 into a date/time field. Basically I want
only actual dates to be allowed to be enterd and 99/99/9999. Is this possible?

Thanks!!!!

Hi Daniel,
you can put 9/9/9999
or 30/9/9999
but you can't put 99/99/9999

The highest number for month is 12, for the day it is 28 or 30 or 31
depending on the month.

Jeanette Cunningham



"Daniel" <(E-Mail Removed)> wrote in message
news:B6A45BDD-F6F0-4223-B9B9-(E-Mail Removed)...
> Hi!!!
>
> I work for a goverment department and look after there databases. I wish
> to
> make it possible to input 99/99/9999 into a date/time field. Basically I
> want
> only actual dates to be allowed to be enterd and 99/99/9999. Is this
> possible?
>
> Thanks!!!!

"Daniel" wrote:

> Hi!!!
>
> I work for a goverment department and look after there databases. I wish to
> make it possible to input 99/99/9999 into a date/time field. Basically I want
> only actual dates to be allowed to be enterd and 99/99/9999. Is this possible?
>
> Thanks!!!!


In the design view of your table, on the field you want the date/time, use
the input mask of : 99/99/0000;0;_

On Tue, 8 Jan 2008 16:53:35 -0800, Daniel <(E-Mail Removed)>
wrote:

>Hi!!!
>
>I work for a goverment department and look after there databases. I wish to
>make it possible to input 99/99/9999 into a date/time field. Basically I want
>only actual dates to be allowed to be enterd and 99/99/9999. Is this possible?
>
>Thanks!!!!

No, because there is not and never will be a date 99/99/9999.

You can use 1/1/9999 or 12/31/9999 but it must be a valid date in the range
between 1/1/100 and 12/31/9999.

John W. Vinson [MVP]

Thanks guys!!!

I knew 99/99/9999 was not a actual date but thought there might be some way
to allow it to be added as a exception or something. I talked with the data
entry crew and told them it was not possible and asked them if 1/1/9999 was
ok. It is.

Once again thanks for your help!