cancel
Showing results for 
Search instead for 
Did you mean: 
rortiz312000
Nintex Newbie

Query List Filtering by Date Range

Jump to solution


Hello,

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!

Labels: (2)
0 Kudos
Reply
4 Replies
teowt
Nintex Newbie
Not applicable

Re: Query List Filtering by Date Range

Jump to solution

Hi,

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.

Thanks

Arun

0 Kudos
Reply
abaid
Nintex Newbie

Re: Query List Filtering by Date Range

Jump to solution

Hi rortiz312000

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

http://vadimtabakman.com/nintex-workflow-querying-a-list-with-paging.aspx

Thanks,

Abaid

Reply
Not applicable

Re: Query List Filtering by Date Range

Jump to solution

Hi,

Its possible.

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.

Good Luck!!!!!!

0 Kudos
Reply