Unfortunately, I will need to include the filter for Status = Completed. I tried using AddDays(UtcNow(), -28) but it did not return any results from the query. What did you mean by test separately? Sorry, a bit of a newbie...
I have a similar code for Status = Pending and EndDate eq AddDays(UtcNow(), -21, 'MM/dd/yyyy') and is working well (EndDate column was manually created vs Modified column from SharePoint default).
So could be that my Modified date/time format in the query is wrong? Do you have another recommendation? Greatly appreciate it!
Auto-delete items based on Modified date (standard format)
Since the internal Dates will be stored in UTC format it would be better to use ISO 8601 utc format for the date when you are querying. I would just do AddDays(UtcNow(), -28). You may also want to test the Status eq 'Completed' piece separately. Status is probably a choice column which is hard to query on.
----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!
Paul Papanek Stork, MVP Blog: https://www.dontpapanic.com/blog
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
300
Share
Report
All responses (
Answers (
