I currently use this WHERE on my reader:
>Last_Updated] < DATEADD(week,-1,GETDATE()) or TLast_Updated] IS NullI now have a need to use the items that are older than 1 week, then another need to process those items that are less than a week old.
I have added a TestFilter, the NULL test is easy, it is the 1 week item that brings me unstuck. Is this possible to do?
Or do I need to add another step in my chain of processes?
Thanks heaps.
Yes, you can do something like this in a tester, test whether the last updated is less than 7 days from today's date
Yes, you can do something like this in a tester, test whether the last updated is less than 7 days from today's date
thats awesome, ill try that now.... I see the -P7D, thats something I havent seen before. What does the P respresent?
thats awesome, ill try that now.... I see the -P7D, thats something I havent seen before. What does the P respresent?
P is a delimiter character denoting period
thats awesome, ill try that now.... I see the -P7D, thats something I havent seen before. What does the P respresent?
Thank you, its working perfectly!