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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Date Query

Status
Not open for further replies.

LCUDK

IS-IT--Management
Dec 21, 2007
42
US
Hello All,

I have a table containing a date field, LastSafetyWalkDTE. Based off of this date field I need to generate a list of any users in the database that have a date in that field older than 3 years from today. Basically, every member has to do a safety walk once every three years. From the query I need to generate a report with names and phone numbers of members that have not done it in over three years.


Any help would be greatly appreciated.

Thanks Again,

Doug
 
Hi,
Code:
dateSerial(year(Date()-3),month(Date()),day(Date()))

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top