I need to filter out records that are newer than 180 days from the current date. I have a field called "Check Date" in this format: mm/dd/yyyy.
Create a filter named "Newer than 180" and give it this expression:
[font="courier"](Today()- ) < 180 /font[/quote]This will show records with Check Dates within the last 180 days.
Thanks....works great as always.
Retrieving data ...