Hi
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!
Thanks
J
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!
Thanks
J