Find rows between two date & time

Hi Knimers,

I have two tables with data.

Table 1 contains:

• Login time (2023-12-11T00:31:21)

• Logout time (2023-12-11T00:39:23)

• IP Address (8.8.8.8)

Table 2 contains:

• Transaction details (many fields like from account, to account, channel etc)

• Transaction date & time until minutes (2023-12-11T00:33)

I want to match these two tables and get the IP Address from the Table 1 to Table 2 to identify the Transaction IP address.

Any suggestions would be highly appreciated.