FormatDateTime shows wrong time for date with daylight saving time
In our application appointments are made in the future and mailed tot the attendants. All dates are localized. 25 march is the date daylight saving time starts. Today is 21 march. When the date is scheduled before 25 march 2018 the datetime is showed right in the email. But when we schedule it after 25 march the datetime is shown one hour too early in the email. The dates are shown in the right way at forms. It seems that when using formatDateTime during a winter time periode, Mendix always uses the winter time for formatting a date that is saved. Although the date saved is in summer time. Is this a bug in Mendix? Has anyone encountered the same problem?
In case you use a date without time it is recommended to set the time part at 12:00 to prevent unwanted daylight savings behaviour.
Chris de Gelder
This is always a difficult topic.
How do you construct the DateTime in the future? Can you be more specific about the logic.
If you create a date in the future, it will use the current time zone in the future unless you specify the time zone in the future explicitely.