Drop record based on date (1 Viewer)

[ChickeyD]

I have a query with two date fields a received date and a field that is adding 60 days to the received date.

What I am trying to do is have a record that with a received date that is greater than 60 days from the date the query is run to not pull on the query.

It needs to run automatically instead of entering new date ranges each time. I know there must be a really easy way to do this, but at the moment I am running into brick walls.

Would someone please help me?

 

[maxmangion]

and a field that is adding 60 days to the received date.

It needs to run automatically instead of entering new date ranges each time.

Do you mean that you are entering the date + 60 days manually yourself?

If yes, search for the DateAdd() function or simply try

NewField: DateFieldName+60