Question

Locked

How do I identify dates that will expire within 30 days

By grblair ·
I have a simple training database to track different training that has been completed by employees. I need to create a way to know if someone is about to expire and provide email notification of that.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

And your Training D Base is in what Program? NT

by OH Smeg In reply to How do I identify dates t ...
Collapse -

Access

by grblair In reply to And your Training D Base ...

The training D Base is in Access.

Collapse -

Something like this

by Tony Hopkinson In reply to Access

DateAdd
If say expire is [DateExpires] <= 30 days then

Select * From [Trainees] Where
[DateExpires] <= DateAdd(days,30,GetDate())

Would do the job.

There are lots of other date functions and here's a bit of help for using 'em in access which is not one of my strong suits.

http://www.databasedev.co.uk/dateadd_calculation.html

Collapse -

know if someone is about to expire!!!???

by Mehul Bhai In reply to How do I identify dates t ...

Only god knows that. Tell him to e-mail you when someone is about to expire!!!??? :0 :0 :0

Collapse -

I'm surprised that you didn't suggest

by OH Smeg In reply to know if someone is about ...

Looking on the Packet for the Expiry Date so you'll know when that packet of Dates is about to expire. :^0

Col

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums