Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
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.
For example:
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?
Thank you,
Dominic
In script, load the date as floor(Date)