09-27-2024 06:54 AM
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?
Solved! Go to Solution.
10-02-2024 10:09 AM
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.
10-02-2024 10:09 AM
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.
10-03-2024 01:31 AM
Thanks @JonG_Validity I can confirm that does what I wanted 👍
Get industry news, expert insights, strategies, and hot tips, served up fresh every week.
Visit the Validity blog