validation rule

[hadeel_albayati]

hi
i have a field as date/time and i want to put a
validation rule on tis field so that any entry that is
more than 7 days ahead of the current date will be
refused with a validation text any help will be very much
appreciated thanks in advance

 

[Allen Browne]

1. Open your table in design view.

2. Select the date/time field (named "MyDate" in this example).

3. In the lower pane, set the Validation Rule to:
Is Null Or <= Date() + 7

4. Set the Validation Text to your message, e.g.:
Cannot be more than one week ahead.