Scenario: I want to query items that were modified in the last 7 calendar days.

How can I query the list to return record IDs: 208, 209, 210

Here with alternatives/tricky solution in creating your workflow.

First solution:

1. Go to workflow designer, drag Calculate date action:

2. Configure the Calculate date as below:

3. Pass the Data and time variable in Query List action:

Second solution:

1. Before creating your workflow, go to your list setting and

• create a new column (Calculated type) named “Last 7 Days” and
• formula as "=aModified]+7"

Note: If you want Date range of 2 days, then you can + 2.

2. After that, the column will be auto shown in your list with formatted value.

Note: The Modified column is auto updated if any changes to the item, the new column that been created will be auto updated as well. Both are not editable.

3. Go to Nintex workflow designer, drag the action Query List and create a “Today date” variable by click on Variables option from Query List action’s ribbon.

4. Click on New button from ribbon.

5. Create “Today date” variable with configuration as below and click save button.

6. Then add a filter rule of “Last 7 days” is greater than or equal to rToday date] in query list action

7. Publish and run the workflow, the result of the Query List action will only return those records that were modified in last 7 days.

8. The result of query will return record ID: 208,209,210

Filter rules: Is greater than or equal to today date (1/15/2015)