When using the date filter in the filter panel, reports, or running a php/ajax query all are off by one day in each direction.
For example we have a daily activity log. I have confirmed that there is an entry for each day in oct. But from the filter panel when you select 7/1/2022 (m/d/y) to 7/4/2022 it will only display 7/2/2022 to 7/5/2022. See screenshot.
When you select the month October in a report, it will show from 7/2/2022 to 8/1/2022.
No changes have been made in the software. Was on 3.1 and to ensure it was not an update issue I updated to 3.2.1 and still have the same issue. As far as I know, no changes have been made on the hosting server. The only thing is we did end Daylight Savings here in the US on Sunday. Could that have an impact?
Everything was working fine until we noticed that it was off in a monthly report we ran for October.
Any help is appreciated!!
Date Filter Suddenly Incorrect
-
- Posts: 13
- Joined: 13 Nov 2020, 01:27
- Name: Unitas Solutions
- Location: USA Raleigh
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Date Filter Suddenly Incorrect
Which version php do you have?
Can you reproduce this issue on personal demo, please?
Can you reproduce this issue on personal demo, please?
-
- Posts: 13
- Joined: 13 Nov 2020, 01:27
- Name: Unitas Solutions
- Location: USA Raleigh
Re: Date Filter Suddenly Incorrect
Yes, we can reproduce this in two different instances. It is an issue with Daylight Savings Time. If we change the application configuration to UTC, everything works correctly. If we go back to America/New_York, it has the issue with the days being off by 1.
PHP Version 7.4.33
PHP Version 7.4.33
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Date Filter Suddenly Incorrect
Can you reproduce this issue on my demo, please?
https://www.rukovoditel.net/demo.php
And give me the link to the demo.
I mean I need to have example with issue to play with this.
https://www.rukovoditel.net/demo.php
And give me the link to the demo.
I mean I need to have example with issue to play with this.
-
- Posts: 20
- Joined: 13 Dec 2021, 17:13
- Name: Waldemar Rychert
- Location: Poland - Gniezno
Re: Date Filter Suddenly Incorrect
We have the same problem. Just noticed today. Did you manage to solve this problem? Is there any solution?
Check on DEMO -> https://pdemo.rukovoditel.pro/3.2/index ... mo_id=1751
Filter on: Oferta z dnia: 2022-08-01 Do: 2022-08-31
You will see two entries from SEPTEMBER.
I noticed that the problem applies only to the period before the change to Winter Time. When we narrow down the dates from September 1 to September 30. When we narrow down the dates from Oct. 1 to Oct. 31, we have a problem at the beginning of the month, and no longer at the end. In November and December, the filter works correctly.
We also use this DATE field in Pivot Tables PRO and it works fine there.
Timezone: Europe/Warsaw UTC+1
Rukovoditel and Extensions 3.2.1 running on 7.4.33
Also we have local copy on PHP 7.4.15 (FreeBSD) and does not work either.
Check on DEMO -> https://pdemo.rukovoditel.pro/3.2/index ... mo_id=1751
Filter on: Oferta z dnia: 2022-08-01 Do: 2022-08-31
You will see two entries from SEPTEMBER.
I noticed that the problem applies only to the period before the change to Winter Time. When we narrow down the dates from September 1 to September 30. When we narrow down the dates from Oct. 1 to Oct. 31, we have a problem at the beginning of the month, and no longer at the end. In November and December, the filter works correctly.
We also use this DATE field in Pivot Tables PRO and it works fine there.
Timezone: Europe/Warsaw UTC+1
Rukovoditel and Extensions 3.2.1 running on 7.4.33
Also we have local copy on PHP 7.4.15 (FreeBSD) and does not work either.
Last edited by ipropoland on 13 Dec 2022, 14:57, edited 1 time in total.
-
- Posts: 20
- Joined: 13 Dec 2021, 17:13
- Name: Waldemar Rychert
- Location: Poland - Gniezno
Re: Date Filter Suddenly Incorrect
Did you manage to check the issue?support wrote: ↑17 Nov 2022, 09:18 Can you reproduce this issue on my demo, please?
https://www.rukovoditel.net/demo.php
And give me the link to the demo.
I mean I need to have example with issue to play with this.
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Date Filter Suddenly Incorrect
Yes, I have found this issue. File from archive replace to includes\classes\reports\
Let me know if it works ok now.
Let me know if it works ok now.
- Attachments
-
- reports.zip
- (9.53 KiB) Downloaded 90 times
-
- Posts: 20
- Joined: 13 Dec 2021, 17:13
- Name: Waldemar Rychert
- Location: Poland - Gniezno