Discussion board where members can get started with Qlik Sense.
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:MMS AM
Go to Solution.
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 ...