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

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

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,

Hello:

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

Regards
Mark

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

Hello:

Your welcome and good luck with this.
Mark