Hi everyone,
I’m trying to solve a filtering issue with Get Row(s) in n8n and would appreciate some guidance.
I have a table with two separate fields:
-
time_sent → contains the time, e.g. “20:03”
-
analyse_7d → contains the date, e.g. “20-11-2025”
What I want to achieve:
Every full hour, I want n8n to query the table for the entry from the previous hour, matching both date and hour.
Example:
If the current time is 21:00, I want to fetch the row where:
-
analyse_7d = today’s date
-
time_sent is within the previous hour (20:00–20:59)
Basically:
How can I filter a single row that matches the current date AND the previous hour using Get Row(s)?
Any hint on how to structure the filter, or whether I need to pre-process the date/time in a Set/Code node first, would be super helpful.
Thanks! 
