Date filter for 'Create Reference"

[renet123]

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.

[khanh]

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

Subtract Days function

End result.

[renet123]

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 ".  

[renet123 · Accepted solution]

Figured it out.. 

Past 7 days... 

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