Date Validation Problom!

[Guest]

I have a filed in my table called Bookig Date and another field called Event
Date.

I wan to create a validation rule for Event Date that makes it to only
accept dates 7 days perior to Booking Date. How can I enter Booking Date
field in the validation rule to create a rule like this: <Booking Date - 7

 

[Rick B]

If the date is ALWAYS 7 days prior, then you don't need it in your table.
You should not store data in a field that is calculated off of another
field. What if the Booking Date is changed - what would prompt you to
change the Event Date?

The proper way to do this is to only store Booking Date in your table. In
your forms, queries, and reports you can calculate and display the Event
date. In a query, for example, you'd add a new column with something like
the following in it...

EventDate: BookingDate-7

In reports and forms, you could add an unbound text box with something like:

=BookingDate-7