Time off 1 hour when edit

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
mpol_ch
User
Posts: 877
Location: Switzerland

Time off 1 hour when edit

Post by mpol_ch »

Hi,
I am having a time field 24h format.

Format: Date/Time
Date /Time format: Time(HHmm)

Extention timepicker is activated:
Step: 15
Options: H:i

Each time when I edit the record the time is reduced for 1 hour, without thouching the time field.
In local setting registered time zone is "Europe/Zurich"

Where to check?

mpol_ch


tom
User
Posts: 118

Post by tom »

id in language file and id from local settings must be exactly the same


mobhar
User
Posts: 11660

Post by mobhar »


mpol_ch
User
Posts: 877
Location: Switzerland

Post by mpol_ch »

thanks for the infos.
I just checked it and there was no difference.
I am only using en-US version.
The issue is not solved.

mpol_ch


arbei
User
Posts: 9292

Post by arbei »

  1. What is database type and data type of the field?
  2. Did you set timezone in your database (not in the project)?
  3. Did you set timezone in the project by the advanced setting "Database time zone (for SET TIME ZONE)"? If so, try remove it either, see if the problem is due to double setting the time zone by both advanced setting and locale.
  4. Your "Options: H:i" is a wrong setting, it should be in JSON syntax. Anyway, time format is determined by your locale's time format.
  5. I tested with "en-US" language ID with your time zone and it is working fine.

mpol_ch
User
Posts: 877
Location: Switzerland

Post by mpol_ch »

thank you for the informaiton.
I still have issue with time_zone.
It working but I am getting 2 hours behind the actuell local time.

It is an imported project from version 2022.
In local setting as time zone is "Europe/Zurich" registered.
The used language is the en-US which has been delivered with application.

My app is time tracking tool and therefore the timecorrectness is important..

thanks
mpol_ch


arbei
User
Posts: 9292

Post by arbei »

You better send your project and database schema to support if you cannot post complete info here for reproducing the problem.


Post Reply