Ensure Date Entered is >= 5 Years in the Future

[mcupito]

Hello, everyone.

I've a form where users are entering data, and one of the fields is an election date, where the date the user enters must be >= 5 years in the future. I am not sure how access accomplishes this.

I thought of a validation rule where [ElectionDate] >= DateAdd("yyyy", 5, Date())

However that did not work. Anyone have any ideas?

Thanks.

[Seth Schrock]

A validation rule should work. Try entering just >= DateAdd("yyyy", 5, Date()). Here is a link that discusses validation rules: Allen Browne Validation Rules

[mcupito]

Ah, thanks! I was adding the Field in the Validation Rule.

Cheers, Seth!