Page 1 of 1

issue with "filter by days" and "filter by week -1"

Posted: 09 Nov 2021, 13:37
by apit
Hello,

there is an issue with setting filters.
If the date interval is in the current month, then the filtering is correct.
Field "Datum" is a "Date with calendar picker".
If "from" is in the past month, then the first day is missing in the filtered records. Instead, the next day after "from" is displayed!
Same shift of +1 day is in "Filter by Weeks"
Clipboard03.png
screenshot: entry from 2021-10-05 is missing, entry from 2021-10-08 is out of filter range

Regards

Re: issue with "filter by days" and "filter by week -1"

Posted: 22 Nov 2021, 18:59
by Carasan
Hello,

currently I have exactly the same problem.
I could relate it to the Daylight Saving time.

The Timestamp from the "From Date 01.10.2021" is 1633039200 but this Date is only displayed when i select the 30.09.2021


(Selected from 01.10.2021 to 31.10.2021 - no Data from 01.10.2021 is shown)
from 1.png
from 1.png (11.63 KiB) Viewed 1363 times
(Selected from 30.09.2021 to 31.10.2021 - Data from 01.10.2021 is shown)
from 2.png
(Same behavior with the "To Date")
to 1.png