Hi all, I have a mf where I parse a string (‘29-03-2021 150000') to dateTime (dd-MM-yyyy HHmmss). The variable that I parse the new dateTime to, shows in the debugger UTC time as 29-03-2021 14:00:00 and localtime 29-03-2021 15:00:00. A localised dateTime attribute is then changed with the content of the variable and then committed. But when showing this date on a page (attribute is localised as said before), it shows 29-03-2021 16:00:00. This is happening with dates as from 29-03-2021 and has to do with DST (Amsterdam). It takes UTC 14:00:00 +2 = 16:00:00 local time to show. What I want is that when I parse a date in the mf, which is in DST (so as from 29-3-2021), that the local time (15:00:00) is set and UTC is calculated back to 13:00:00. But it seems that the mf does NOT take DST into concern, but the page (or DB) does. Result: the local time on the page is 1 hour off. If anyone has experienced the same or has a clever solution for this, then pls. let me know. Thanks in advance. Mendix Studio Pro 8.17.0 Regards, Roel
asked
Forgotten User RDYNBeUw2t
1 answers
0
As Queues are executed in system context, Daylight Saving Time (DST) is not taken into account. Solution is to use a java action to trigger the MF for date/time calculation within the queued MF. eg. CommunityCommons.executeMicroflowAsUser_1