Date Filter Suddenly Incorrect

[unitassolutions]

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!!

[support]

Which version php do you have?
Can you reproduce this issue on personal demo, please?

[unitassolutions]

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

[support]

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.

[ipropoland]

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.

Filter problem

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.

[ipropoland]

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.

Did you manage to check the issue?

[support]

Yes, I have found this issue. File from archive replace to includes\classes\reports\
Let me know if it works ok now.

[ipropoland]

Yes, I have found this issue. File from archive replace to includes\classes\reports\
Let me know if it works ok now.

Yep! It works correctly now. Thank you.