Date formatting Issue in CSV Export

[sunil_vjr]

Hi,
I am trying the export the CSV from the report and the report contains some date fields. I need to format those dates in "yyyy-MM-dd" format. It works fine while viewing in the report but when I generate the CSV file, it is displayed in "MM/dd/yyyy" format. I need to show it in "yyyy-MM-dd" format while export it from the code. How can I fix that?

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue.
Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

[sunil_vjr]

Hi Lech,
You could take any date value and do the custom format the date into "YYYY-MM-dd" and save the report. But when you tried to save data in csv file, the format of the date is not according to the custom format that I have set.

Screenshot 2024-03-25 112249.png (194.36 KiB) Viewed 696 times

Screenshot 2024-03-25 112430.png (20.23 KiB) Viewed 696 times

[sunil_vjr]

Hi Lech,
The version that we are using is 2022.4.5. May be the issue is in that version?

[Lech Kulikowski]

Hello,

Excel itself may not display it correctly.
If you open the file in the editor, the date is correctly written there.

Thank you.