topic != TODAY in DemandTools

!= TODAY

Matthew_Rushton — Fri, 27 Sep 2024 13:54:00 GMT

In DemandTools you can add a relative date operator of TODAY TOMORROW, YESTERDAY, but if you want to go further back or forward you can use < or > LAST_N_DAYS or NEXT_N_DAYS.

Question is, if I want to exclude records created 'TODAY' would that be < LAST_N_DAYS of 0 or 1?

Re: != TODAY

JonG_Validity — Wed, 02 Oct 2024 17:09:04 GMT

Hi @Matthew_Rushton I am loving that you're thinking outside the box on this one - I did some testing within my environment and was able to achieve this by using the criteria < LAST_N_DAYS of 0. During my testing, this pulled in records that were edited yesterday and days prior, but none from today.

I would suggest running a quick confirmation with your data set and if you see different results let me know and I'll see if I can think of another solution.

Re: != TODAY

Matthew_Rushton — Thu, 03 Oct 2024 08:31:37 GMT

Thanks @JonG_Validity I can confirm that does what I wanted 👍