Excel exporter localised datetime

8
Hello. I'm generating a report from entities which have datetime fields, using newest excel exporter. In application those attributes are localised since I'm using both date and time and can't change it. Problem is that dates are exported to excel as UTC and don't match with displayed values. I must have those dates localised in report too. Do you know solution without changing attributes to non-localised?
asked
1 answers
2

Use the formatDateTime function to change the date into a string with the time zone. See documentation here: https://docs.mendix.com/refguide/parse-and-format-date-function-calls

So use something like

formatDateTime($yourDate,'EEE, d MMM yyyy HH:mm:ss Z')

This will result in

'Sun, 8 Jun 2008 10:12:01 +0200'

And that makes it human readable with the timezone.

Regards,

Ronald

 

 

 

answered