Export to excel button datagrid wrong datetime values
0
I have a simple grid with, amongs others, datetime fields. When I use the build-in Export to Excel Button, all fields are correct, except these datetime fields. Almost all of them get exported with the date set to 31-12-2023. Some have a different date. But none have the actual date that I see on the screen. When I change the setting of this button to export date fields as text instead of date value, it exports them correctly. Is this a bug? To clarify, this is the build-in Export to Excel button. Not a microflow button or some other widget. I cannot use the debugger.
asked
Joël Boosman
1 answers
0
Hi Joel,
It takes Localezed/Non-localized dates based on how it was set at the attribute level.
So please check your entity and check the attribute whether localized is enabled (meaning date will be changed based on the user timezone).
And you can toggle the option and observe the excel exporter output.