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
Figured it out..
Past 7 days...
Date greater than [Subtract Days ([Now], 7)]
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 ".
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
