Question

Document template UTC datetime

0

I have a record with a DateTime, it displays correctly on the form, 11:00. However, using it in a document template displays the attribute as 09:00 (UTC?). How to make the document template display the localized time?

asked 2015-05-27

Gerard Veurink

1 answers

Sebastiaan van den Broek · Answer 1 · 2015-05-27

That will depend on the timezone that is used in the microflow with the 'Generate document' activity. If this is done by a scheduled event, it will use the 'Scheduled event time zone' as set in the project settings. If the microflow is triggered by a user, it will use the selected timezone of the user.

Also note that the client (browser) timezone is independent of the timezone that the user selected in his user settings (the association with the System.TimeZone table), if the user has selected the UTC timezone there then it will still render as UTC even if the browser does localize the time correctly.

For further reading, check https://world.mendix.com/display/refguide5/DateTime+handling+FAQ, especially the section "What is the purpose of setting a time zone for a user?". In fact, this exact case is mentioned here: "This means that users should set their time zone to the one their browser runs on, or they might notice discrepancies in what is displayed in their browser and (for example) generated documents or formatted strings."