renet123
Rookie

Date filter for 'Create Reference"

Jump to solution

I want to give a pre-thank you for anyone that helps me on this. 

 

In a k2 workflow, I have a Create Reference flow point for a smart object using the Get List Items method. 

I am trying to filter and retrieve all records for "today and the past 7 days",  and I cant seem to figure out the logic of filtering data for a date field.

Labels: (1)
0 Kudos
Reply
3 Replies
khanh
Nintex Employee
Nintex Employee

Re: Date filter for 'Create Reference"

Jump to solution

Hi renet123,

 

Maybe you can use the Today and Subtract Days to achieve this scenario. In my example, the filter is setup to return Today 10/21 and yesterday 10/20 and the day before yesterday 10/19.  You will likely have to add few more conditions to the filter. 

 

Filter setup

Image 1006.png

Subtract Days function

Image 1007.png

End result.

Image 1008.png

 

0 Kudos
Reply
renet123
Rookie

Re: Date filter for 'Create Reference"

Jump to solution

i think this would work, but what i think is happening is that the Start Date filter is looking for an 'exact date, minute, and second', when i all i want is the date.  My filter finds nothing because the time/seconds are not exactly "10/25/2021 12:00:00 AM ".  

0 Kudos
Reply
renet123
Rookie

Re: Date filter for 'Create Reference"

Jump to solution

Figured it out.. 

Past 7 days... 

Date greater than [Subtract Days ([Now], 7)]

renet123_0-1635283603039.png

 

 

View solution in original post

Reply