Date filter for 'Create Reference"

  • 22 October 2021
  • 3 replies

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.


Best answer by renet123 26 October 2021, 23:28

View original

3 replies

Userlevel 1

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.


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

Figured it out.. 

Past 7 days... 

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