Extract records within x minutes of time from another table

I have two tables, the first one as followed:

Table 1
2020-01-12 11:58:35 Peter
2020-01-12 12:13:10 Mary
2020-01-12 12:40:04 Dave

Table 2
2020-01-12 12:01:15 123456

How can I extract the records in Table 1 from the time +/- 15 minutes in Table 2, so that both Peter and Mary will be extracted but not Dave?

Have a look at the Time series nodes. You can create 2 dates (start, end) by adding/subtracting the 15 min (Date&Time Shift) and then filter by date range on table 1.

image

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.