By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

Ensure Date Entered is >= 5 Years in the Future

100+
P: 294
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.
Nov 25 '13 #1

✓ answered by 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

Share this Question
Share on Google+
2 Replies


Seth Schrock
Expert 2.5K+
P: 2,941
A validation rule should work. Try entering just >= DateAdd("yyyy", 5, Date()). Here is a link that discusses validation rules: Allen Browne Validation Rules
Nov 25 '13 #2

100+
P: 294
Ah, thanks! I was adding the Field in the Validation Rule.

Cheers, Seth!
Nov 25 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.