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.
Solved! Go to Solution.
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.
Subtract Days function
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 ".