when date field filter set to 31.03.2024(sunday) it shows results for 01.04.2024(monday) for some reason. Other dates I tried seem to be working fine, like other sundays or other 31 end of month dates.
Strange issue with date filter
-
p.dimitrov
- Posts: 166
- Joined: 12 Jul 2017, 09:35
- Name: Pavel
- Location: Varna
Strange issue with date filter
Today we noticed something very strange:
when date field filter set to 31.03.2024(sunday) it shows results for 01.04.2024(monday) for some reason. Other dates I tried seem to be working fine, like other sundays or other 31 end of month dates.
when date field filter set to 31.03.2024(sunday) it shows results for 01.04.2024(monday) for some reason. Other dates I tried seem to be working fine, like other sundays or other 31 end of month dates.
-
p.dimitrov
- Posts: 166
- Joined: 12 Jul 2017, 09:35
- Name: Pavel
- Location: Varna
Re: Strange issue with date filter
Ok looks like it has something to do with time zones and maybe the summer time change:
Assuming that this timestamp is in seconds:
GMT: Sunday, March 31, 2024 9:00:00 PM
Your time zone: Monday, April 1, 2024 12:00:00 AM GMT+03:00 DST
It's correctly set in rukovoditel, server and php I think.
Assuming that this timestamp is in seconds:
GMT: Sunday, March 31, 2024 9:00:00 PM
Your time zone: Monday, April 1, 2024 12:00:00 AM GMT+03:00 DST
It's correctly set in rukovoditel, server and php I think.