Adding 99/99/9999

[Daniel]

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!!!!

 

[Jeanette Cunningham]

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

 

[SpaceCadet!]

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;_

 

[John W. Vinson]

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]

 

[Daniel]

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!