filter by date problem

[dominicanlauf]

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

[m_woolf]

In script, load the date as floor(Date)