Validation Rule for Date

[hendrahen]

Hi

I have a table with 2 field:
1. StartDate (format : Short Date)
2. EndDate (format : Short Date)

How can I validate for field EndDate must occur after StartDate using Validation Rule?

Thanks before.

 

[Isskint]

You need to create a Table level validation NOT a field level validation. With the table open in design view, right click and select Properties. In the Validation Rule box enter [EndDate]>[StartDate]. Dont forget a meaningful validation text

 

[hendrahen]

Thanks alot Isskint