Timezone incorrect for ExcelImport

Hi, I'm using Mendix 9.18.4, ExcelImport 10.3.0, CommunityCommons 10.0.0 and I'm reading an Excel file with dates in it: 1-4-2023. I'm in timezone Amsterdam (winter=+1, summer=+2). Obviously 1-4-2023 is summertime and it should store this in de database as 2023-03-31 22:00.  Unfortunately this is not the case; it stores 2023-03-31 23:00. If I use an IVK flow in my ExcelImporter and use a breakpoint, it also shows 2023-03-31 23:00 as the UTC time. Where does this go wrong? Hope anybody can help. Regards, Wieger Vonk
1 answers

What is the default timezone setting of your app? If it is Europe/Amsterdam, can it be that Day Light Saving difference isn't taken into account?


The best approach would be to build up a new date time based on the date from the Excel.

You can import the date with UTC and then use ‘TrimToDays’ for example.