Good morning, updated version 2020, MS access 2007 database. The dates are saved correctly, but the page list appears a day earlier. I have tried to format the fields in dd / mm / YYYY, in dd / mm / YYYY H: i, I have tried them all.
Thanks for your help
Make sure you have already adjusted the “Time zone” directive from “Tools” → “Locale Settings” → then select the .json file related to the language file(s) that used by your PHPMaker project, and then re-generate at least the locale .json file(s).
already done. I also uninstalled everything, absolutely everything, but nothing. No changes.
Dominik04 wrote:
I have tried to format the fields in dd / mm / YYYY, in dd / mm / YYYY H: i
How did you do this? Is it from Fields setup or from .json locale setting file or using any server events/client scripts?
Hi, I understand the error reported. Save the field correctly: if the Data Time field is CurrentdateTime, save the correct value in the DB Access (03/06/2020 08:05:03).
But in the list page it shows me (03/06/2020 06:05:03), 2 hours before.
So if a field is set only on date (03/06/2020) in the page list it subtracts 2 hours and shows 02/06/2020 22:05:03. The Time zone settings are all right.
In fact with Mysql I don’t find these problems, only with DB Access they happen.
I also find the problem that dates higher than April 2038 bring them back to 01/01/1970.