Date Filtering - Qilk Sense

[#1]

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

[sinanozdemir · Accepted solution]

Hi Barry,

You can try to handle this in your WHERE clause:

WHERE OPNDAT = Today() and OPNDAT <= Today() - 120.

Hope this helps.

[#3]

That did it Thank you ...