Validation Rule

  • Thread starter Thread starter Shark
  • Start date Start date
S

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!
 
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!
 
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!
Click to expand...

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.
 
Back
Top