Validation Rule DO NOT work

[Matizo]

Hello,
I have table tblMembers where I have a field Date of Birth (DOB) i set a input mask 00/00/0000;0;_ and validation rule <Date() . But when I have entered 31/01/1985 an validation rule has blocked it. Besides when I have entered 29/01/2008 the msg has not come up! What is a problem?

P.S: When I tried it, the date was 30/01/2007.

Thanks,
matt

 

[mhartman]

Hello:

In your table design place,
00/00/0000 for the Input Mask, and
dd/mm/yyyy for the Format section.

Then try to enter your data

Regards
Mark

 

[Matizo]

What did you mean by 'format' section? The Format section under the general section of the field?
If yes, then it still does not work.

Regads,

 

[mhartman]

Hello:

Enclosed is an example. Enter a date later than today and notice the message.

Regards
Mark

 

[Matizo]

Thanks that works I made stupid mistake, as the Data Type I gave Text not the Date/Time. That's why it did not work.

Thanks again,
Matt

 

[mhartman]

Hello:

Your welcome and good luck with this.
Mark