i need to filter results which shows only dates in a specific 10 day window. Basically i what to show all records where dates are +10 and + 20.
Appreciate any help that anyonce can give on this.
A filter on:
(Today()-[DateField])<10 .and. (-Today())<20
should do the trick.
I have tried this but it also returns results in the next 10 days which i dont want. Is there something that needs to be adjusted?
Sorry Gico, I misread your question. Try today()-Date for both expressions and check the < and >.
Retrieving data ...