Two date colums that filter another one

[Torvi]

Hi guys,

I've been struggling with this problem for the last days.

I have 2 tables, that are in 2 different tabs.

Cycle

There are 2  timestamps : Cycle start and end. 

MachineData

There is only one timestamp : DateAndTime

I was able to automatically filter the machine ID from one table to another.

My use case is the following :

I would like to automatically filter the MachineData.DateAndTime field based on the [Cycle.Cycle start] and  [Cycle.Cycle end] values.

In that example, I would like to have MachineData.DateAndTime between 11.01.2023 14:02:30 and 12.01.2023 09:28:43.

Thanks for your help 🙂