Question Locked
0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.
6 replies
by grblair Accepted solution
Clarifications
by oh smeg Accepted solution
:0
by grblair Accepted solution
The training D Base is in Access.
by tony hopkinson Accepted solution
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.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies