Comparing two fields in a table

[Wolff]

How do you compare two fields in a table for instance you want to
compare two date field such that Date1<Date2 what do you type in the
validation rule box. I have tried <Date2 which doesn't work and
<[Date2] gives me an error.

 

[OldPro]

How do you compare two fields in a table for instance you want to
compare two date field such that Date1<Date2 what do you type in the
validation rule box. I have tried <Date2 which doesn't work and
<[Date2] gives me an error.

Validation Rules cannot contain references to forms, tables, or other
fields in the table. Put the validation code in the BeforeUpdate
event instead.