Filter table based on scheduled trigger
I have a process that uses 2 scheduled triggers daily. The first run is at 7:00 AM and the second run at 5:00 PM.
In the process, I want to filter a large data table from a different process for only the rows that got added after the previous run, e.g. for the process that runs at 5 PM, I want to only filter for rows that got added between 7 AM and 5 PM on that same day.
How can I set up my filter accordingly? Do I have to use the "Adjust a date & time" action in order for this to be feasible?