+8I currently use this WHERE on my reader:
[Last_Updated] < DATEADD(week,-1,GETDATE()) or [Last_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.
Best answer by ebygomm
Yes, you can do something like this in a tester, test whether the last updated is less than 7 days from today's date
+44Yes, you can do something like this in a tester, test whether the last updated is less than 7 days from today's date
+8Yes, 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?
+44thats 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
+8thats 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!
