Date search query

Jan 14, 2015
Reaction score

I am trying to set up a query whereby I search all entries within an area range with a end date between today and 6 months from today.

In the criteria for area I have: Between 0 And 599

I cannot find anything that works in the EndDate field though to produce all the data without having to manually enter the date. Is there a criteria where it will pick the current date and produce the 6 months worth of data or do you need to enter in a date+180 to get the results?

Any help would be much appreciated!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question