Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks
Hi Barry,
You can try to handle this in your WHERE clause:
WHERE OPNDAT = Today() and OPNDAT <= Today() - 120.
Hope this helps.
Hi Barry,
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 ...