cancel
Showing results for 
Search instead for 
Did you mean: 

!= TODAY

Matthew_Rushton
Contributor

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?

1 ACCEPTED SOLUTION

JonG_Validity
Validity Team Member
Validity Team Member

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.

 


Regards,

Jonathan Greenip
Customer Success Manager

View solution in original post

2 REPLIES 2

JonG_Validity
Validity Team Member
Validity Team Member

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.

 


Regards,

Jonathan Greenip
Customer Success Manager

Matthew_Rushton
Contributor

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