Date validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dudley - 17 May 2007 15:17 GMT

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

Reply to this Message

George - 17 May 2007 15:23 GMT

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" έγγραψε:

> 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
[quoted text clipped - 5 lines]
>
> Dudley

Reply to this Message

Dudley - 17 May 2007 16:16 GMT

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

> Dear Dudley,
>
[quoted text clipped - 19 lines]
> >
> > Dudley

Reply to this Message

RBear3 - 17 May 2007 15:23 GMT

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

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

Signature

Hope that helps!

RBear3
.

>I have a field on a form which requires a date of birth in the (British)
>form
[quoted text clipped - 7 lines]
>
> Dudley

Reply to this Message