Validation of dates

Hi Julie,

Thank you for your question.

If you go into design view of the table and click into the Validation rule property field.

Type the following: >date() - which means greater than the current date.

Now type the Validation text to explain the rule.

Alternatively you could set up a query and add a calculated field that works out the delivery date.

E.g. DeliveryDate:[OrderDate]+7 - If the delivery date was always 7 days later.

I hope this answers your question.

Regards

Simon