Date validation

[Dudley]

I have a field on a form which requires a date of birth in the (British) form
31011970, or the field to be left blank. I have tried putting validation
rule: like "????????" or null, which works as far as it goes, but I would
like to make it more sophisticated, ideally a valid date between 1 Jan 1907
and 1 Jan 1990.

Any advice gratefully received.

Dudley

 

[George]

Dear Dudley,

I assume that your field is of date/time data type. So, the user must
record 31/01/1970.

The validation rule, then, should be
between #1/1/1907# and #1/1/1990# - both dates will be accepted.

Hope this helps,

GeorgeCY

Ο χÏήστης "Dudley" έγγÏαψε:

 

[RBear3]

Just put something like the following in the control's validation rule...

Between #01/01/1907# and #01/01/1990#

 

[Dudley]

Dear George,

Thanks for the advice. Unfortunately the field is a text one. At the time
with my limited knowledge I thought this would be easier as I have to output
in the form 31011970 without the slashes. I will have to think whether it is
worth the trouble of changing it a date field.

Dudley