Hello,
In my GQI script i use a column of type “GQIDateTimeColumn“.
I set a DateTime for the cell using Value (DateTime) –> “eventStart” which is of type DateTimeKind.Utc.
new GQICell{ Value = eventStart},
Example of displayed value in UI : 12/06/2024 13:12:00
I want to display the same DateTime but with a different format using DisplayValue (string) :
new GQICell{ Value = eventStart, DisplayValue = eventStart.ToString(“dddd dd MMMM yyyy HH:mm”)},
Example of displayed value in UI : Wednesday 12 June 2024 12:12
Why is the hour different (12:12 instead of 13:12) , and how to fix it. It is supposed to be the same UTC datetime in both cases.
Hi Kevin,
This is because your client machine is using a different time zone than the DMS. When not configuring a custom DisplayValue, GQI creates one itself by using the time zone info from the client. When you define this yourself in a custom data source/custom operator, the client time zone is unknown.
Currently, there is no way to get time zone info of the client in your script. I have created a feature task to make this possible.
Hi Wout,
Thanks for the feedback and for creating a feature task to resolve it!
Kévin