Help with dates

[dsomers]

I'm creating a query that will provide me with people that have their lease expiring in the next 60 days from whatever date the query is ran. However, I can't think of how I would specify that in the criteria for my query. Can't somebody help me with this?

Thanks!
David Somers

 

[mark curtis]

in the lease expiring date field in the query criteria put <date()+60

this will return all data with renewal dates up to 60 days in advance