Date calculation

[gary g]

In my query I want to enter a new expression into the Field row that will restrict the query to a date range from the current date (whatever it may be) to a date 60 days previous. I know the expression for a specific date range would be something like the following:
=DateDiff("d",[name of a date field],Date())

However, since the actual date pertaining to the start of any 60 day window will always be a variable, I am not sure how I would phrase the expression. The only constant would be the current date, i.e. Date()

Can anyone help? Thanks.

My error: In the formula I wrote above I meant to type this expression:
Between[Start Date]And[End Date]

For a date range between the current date and the variable date of 60 days previous, how should the expression be written? Thanks and sorry for confusing anyone.

Gary

 

[Brianwarnock]

In the Criteria for the date field put

>=(Date()-60)

Brian

 

[gary g]

Thanks Brian. I knew it was simple, but couldn't remember the exact phrasing. Appreciate your help.