I'm currently using a Query List Action in Nintex 2010 and need to only look for items that were modified in the last 7 calendar days. Is it possible to filter by that date range? If so what would be the formula?
Thanks in advance!
Solved! Go to Solution.
1. Sore the Last 7 days details in date variable type by using calculate action item (Days -7)
2. Use Query list action item, apply filter on created is greater then date variable type and get last 7 days item id's.
If Query list action does not help you to achieve your desired result, you can try using 'Call Web Service' Action and directly query this list.
It will provide much more flexibility.
This article will guide you
1st create a column in your list to store every items by created date.
before query list use a "calculate date" workflow action to get the last day of week and store the value in a variable.
In query list you will see a filter option , use below formula
created date "is greater or qual to" the variable which you filled from calculate date workflow action.
Hope it will help.