Good Morning Everyone,
I am trying to build a formula that would filter the number of new accounts that my Sales Team opened in the last 120 days.
My Field is called OPNDAT and the formatting is M/DD/YYYY HH:MM:SS AM
You can try to handle this in your WHERE clause:
WHERE OPNDAT = Today() and OPNDAT <= Today() - 120.
Hope this helps.
That did it Thank you ...
Retrieving data ...