Solved

Date filter for 'Create Reference"

  • 22 October 2021
  • 3 replies
  • 4 views

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.

icon

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)]





 



 

Reply