Validation Rule - Expiry Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
Back
Top