When running an AOR Report using two date parameters to filter the data, the report returns the date parameter in UTC and off by a day. When initially running the report, the date parameters are set to ‘07/01/2021’
After the report runs, the date parameters have been modified:
Any thoughts on what is causing this issue and how to fix it?
There are two php.ini files where you need to set up a parameter called date.timezone
It’s possible that you only set it up in one of them, go look for the CLI php.ini file which is the one that Scheduled jobs use.
Type this in the command line to find it:
php -i | grep php.ini
I have verified that both php.ini files have the date.timezone set to “America/New York” This issue happens both locally using apache on a mac and hosted in host gator cloud provider.
I see a bunch of undefined in your screenshot, do you have more of those in other screens?
That would be a sure sign of ownership/permissions problems, and can cause tons of different malfunctions
