Validation Rule - Expiry Dates

S

Steve

Hi
I have a programme that records all training records and need a rule that
flags up when the expiry date is due e.g a few weeks before, any ideas on how?

Thanks
Steve
 
J

Jeff Boyce

Steve

I have no idea what your data structure might be, so this is a general
response...

Create a query against the table that has the expiry date field and include
that field.

Use the DateAdd() function to add a criterion for that field -- add 3 weeks
to Date() (today's date) and check if Date() + 3 weeks is more than your
expiry date. You may also want to filter out expiry dates in the past...
 
Top