Help with date in query

Losartan

Registered User.
Local time
Today, 14:12
Joined
Jul 21, 2005
Messages
39
I'm trying to run a query that will show when something is due within the next 90 days.

I keep track of employees competencies that they complete. I want to run a query that will only show me when the field [Renewal Date] is within 90 days of the current date the query is run. How can I do that?

Thanks,
Jason
 
Try something like

WHERE DateDiff("d",Date(),[tablename].[Renewal Date])>=0 AND DateDiff("d",Date(),[tablename].[Renewal Date)<91

Bryan
 
That worked perfectly!! Thanks Bryan.

Jason
 

Users who are viewing this thread

Back
Top Bottom