Date Validation Issue

R

ridawg

Hey,

I'm trying to create a validation rule on a Date field and I've run into a
problem. Here's what I'm trying to do:
1. I have a date field called Action Date. This field cannot be less than
another date field called File Date.
2. So I created a validation rule on the Action Date field that states the
following:
Action Date < File Date. So when the Action Date is less than the File Date
a dialog box pops up telling the user about the error.

Here's the problem. When the Action Date is equal to the File Date sometimes
the validation pops up the dialog box indicating an error. This isn't
correct. It's ok if the date fields are equal each other.

Not sure what I'm missing.
 
J

JonB

ridawg said:
2. So I created a validation rule on the Action Date field that states the
following:
Action Date < File Date. So when the Action Date is less than the File Date
a dialog box pops up telling the user about the error.
Click to expand...

Change this to Less than or Equal To
 
R

ridawg

JonB,

It's ok if the fields are equal to each other. If I change this to Less Than
or Equal To then if the date fields are equal to each other the error message
will pop up.

I only want the error message to pop up when the Action Date is Less Than
the File Date field. For some reason InfoPath seems to pop up the error
message when the dates are equal to each other.
 
Top