Validation Rule

[Shark]

I'm trying to enter an expression in "validation rule" so
that any date entries in my report that are on or before
January 1, 2000 will receive a message that says "the date
is invalid". I'm entering "the date is invalid" in the
validation text line. My problem is that the expression
I'm entering under "validation rule" is incorrect. I've
tried <=#01/01/2000# and several variations on that, but
none are working. Thanks for the help!

 

[mackie]

try to set the field format to mm/dd/yyyy
then place your validation rule
i.e. <=01/01/2000

i just tried it.... it works!

 

[John Vinson]

I'm trying to enter an expression in "validation rule" so
that any date entries in my report that are on or before
January 1, 2000 will receive a message that says "the date
is invalid". I'm entering "the date is invalid" in the
validation text line. My problem is that the expression
I'm entering under "validation rule" is incorrect. I've
tried <=#01/01/2000# and several variations on that, but
none are working. Thanks for the help!

If you want a message to appear on earlier dates, change the <= to >=.
A Validation rule fires when the data entered VIOLATES the rule - as
you have posted it, you would only be allowed to enter dates before
1/1/00, and would get the error message for any later date.