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
View originalHi 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)]
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
