Hey there, I'm using Mendix’ basic logic to export some data from a datagrid to an Excel file. I'm using the same date/time attribute, with custom formats for each column, to display the day, week, month and year of said date/time attribute. However, using either the 'w’ or 'ww’ format to display the weeknumber do not seem to work, as the data comes out as shown in the screenshot below. Not sure whether or not this is a bug, and couldn't find any previous posts regarding the subject, so I'm checking to see if anyone has experienced this behaviour before. Thanks!
Nils de Vries
That is a bug. Workaround is to do the parsing in a microflow and store it in a string or integer.