Criteria Question

[mlr0911]

Hello all,

I have a field name called check_date; I am trying to get a date range of 12/10/2006 and 12/14/2006. I was using between [Enter Date1] and [Enter Date2].

However, I need to get a date from 60 days ago (I am using now()-60 to get this) and use that date against the query.

Is there a way to automate this? Like between 12/10/2006 and now()-60 (which would give me the date of 12/14/2006 from today).


Thanks for your help.

 

[mhartman]

Yes

Date()-60 will give a date that is 60 days from now

Regards
Mark

 

[LuisMartins]

I suggest the dateadd function....

 

[Wiz47]

One more alternative ...

WHERE ((Check_date+60)=Date()))