Forum Discussion
Torvi
3 years agoRegular Visitor
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