Different values for date time property in UI and Clipboard
Hello Everyone,
I'm facing an issue regarding the Date time control that is sending incorrect time to the clipboard.
The image below shows the date and time choosed:
At the control i have a "Post Value" action configured to send the date time value to the clipboard on change but as you can see in the next image, the value for the "DtInicio" property is beeing updated with a different value than it was selected in UI.
One thing that is curious is that the time on the clipboard its always three hours longer than the time selected in the UI date and time control.
Can anyone help me to solve this issue?
Ps.: The time zone selected for my operator is America/Bahia.
Thanks in advance.
Accepted Solution
Updated: 3 Dec 2020 13:16 EST
Agriculture Victoria
AU
This is expected behaviour.
The clipboard shows GMT value for DateTime properties. As America/Bahia has 3 hours offset from GMT (UTC - 03:00), the time that is stored in database will be 3 hours greater than what it shows on the clock in Bahia, Brazil. Please note that when the DateTime shows in clipboard, it also shows the timezone related to that value, which is GMT (not GMT -03:00).
Hope this helps
Capgemini
BR
@MarcLasserre_GCS thanks for your reply!
When i look in UI Gallery its presenting the data correctly as you can see below:
but when I check the value on the clipboard it is still incorrect as you can see below:
Pegasystems Inc.
FR
Hello,
Is it a time zone issue as described in here: https://collaborate.pega.com/question/date-time-selection-calendar-icon-updating-wrong-values-clipboard-pega-717
Maybe the timezone on the server is different to the one on your database?
Accepted Solution
Updated: 3 Dec 2020 13:16 EST
Agriculture Victoria
AU
This is expected behaviour.
The clipboard shows GMT value for DateTime properties. As America/Bahia has 3 hours offset from GMT (UTC - 03:00), the time that is stored in database will be 3 hours greater than what it shows on the clock in Bahia, Brazil. Please note that when the DateTime shows in clipboard, it also shows the timezone related to that value, which is GMT (not GMT -03:00).
Hope this helps
Pegasystems Inc.
AU
Hi @RenatoC3
@PraveenPuri is correct here. To be clear though:
- 27/11/2020 1:43 (America/Bahia time); and
- 20201127T044300.000 GMT
... are two different ways of representing the same moment in time. One is not three hours later than the other; they are the same moment in time shown in different timezones.
All datetimes on Pega's clipboard and in the database are stored in GMT; All datetimes shown on a Pega user interfaces are timezone-converted to the timezone of the current Operator.
This is so that any Operator looking at a date/time can trust that they are seeing the time converted to their local time.
Updated: 3 Dec 2020 13:20 EST
Capgemini
BR
Thank you for your help @PraveenPuri and @BraamCLSA!!