Forum Discussion

Torvi's avatar
Torvi
Regular Visitor
3 years ago

Two date colums that filter another one

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 🙂

 

 

No RepliesBe the first to reply