Hash variable datetime showing -1 hour

 
1
0
-1

Hi every one,

In a date&time field of a form I have a hash variable to set the field at the current time.

When opening the form, the field is actually 1 hour behind that of the system.

I checked all the config options related to time zones but couldn't find the solution:

  • Joget settings : 

  • Mariadb SYSTEM_TIME_ZONE Global_Value is Paris, Madrid
  • Mariadb session Time_Zone is System

 

  • Weirder is that "dateCreated" and "dateModified" fields in the DB are actually at the right time. It seems like my issue is with the #date.dd/MM/yyyy H:mm#

Any ideas?

Thank you very much

Baptiste

 

 

 

    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      Hi Anders,

      Yes, I checked the individual time zone setting in the User Profile, it was also GMT +1

      But I found my error! I was making a mistake between GMT +1 (which has no summer time) and CEST which has.

      So I switched in CEST and now it displays the correct time. Sorry for the stupid question in the first place.

      Thank you anyway.

       

      Baptiste

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi, did you try to check the user's individual time zone setting in the User Profile? 

          CommentAdd your comment...