Validation Rule for a Date Field

G

Guest

I am trying to write a validation rule for a date field in a table. A
valid entry for this field/rule would be a date between 25 years ago (in the
past) from today (the day the record was added) and 14 days from today (in
the future). Since the date range would be based on the date() function it
would allow this "window" od dates to roll forward. Any suggestions on how
I would write the rule?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Rule in Access 2007 3
Validation Rule - Date change update record 11
Table Validation rule 2
Validation rule build on other field in the same table 5
Date Validation Problom! 1
Validation Rule Problems 2
Validate a Date 1
Table Validation Rule for Date 1

Top