I have a production log that covers every manufacturing cycle. The protocol saves a timestamp at the beginning and at the end. If I want to filter the data for a certain period, I have to choose a combination of calendar week and day. If I filter everything by date using the date (timestamp) function, I get the date as a filter function for each production cycle.
10/10/19 10:10:10 start
10.10.19 10:11:11 end
10/10/19 11:11:11 start
10.10.19 11:12:12 End
I get the filter 10.10.19 twice and it stands for only one production cycle.
Does anyone know how to solve this problem so that I can filter by date?