This should be simple for all of you SQL experts. I need to query a table for all dates over one year old and display them. This is needed to track when personnel are due for test dates. Tests are an annual requirement, so when the current date (July 8, 2004) plus 30 days (August 8, 2004) minus one year (August 8, 2003) would notify all students they need to retest within 30 days or their certifications will expire. I want anyone whose expiration date is before or on August 8, 2003 to show up in the query. I look forward to your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Specific Query
- Thread starter okstate12
- Start date
SkipVought
Programmer
Hi,
[tt]
Where [TestDate]<=(DateSerial(Year(Now)-1, Month(Now)+1, Day(Now))
[/tt]
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
[tt]
Where [TestDate]<=(DateSerial(Year(Now)-1, Month(Now)+1, Day(Now))
[/tt]
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question