Help with date in query

[Losartan]

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

 

[BryanT]

Try something like

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

Bryan

 

[Losartan]

That worked perfectly!! Thanks Bryan.

Jason