Page 1 of 1

Date formatting Issue in CSV Export

Posted: Fri Mar 22, 2024 11:58 am
by 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?

Re: Date formatting Issue in CSV Export

Posted: Fri Mar 22, 2024 10:28 pm
by 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.

Re: Date formatting Issue in CSV Export

Posted: Mon Mar 25, 2024 3:27 pm
by 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
Screenshot 2024-03-25 112249.png (194.36 KiB) Viewed 1114 times
Screenshot 2024-03-25 112430.png
Screenshot 2024-03-25 112430.png (20.23 KiB) Viewed 1114 times

Re: Date formatting Issue in CSV Export

Posted: Mon Mar 25, 2024 3:58 pm
by sunil_vjr
Hi Lech,
The version that we are using is 2022.4.5. May be the issue is in that version?

Re: Date formatting Issue in CSV Export

Posted: Mon Mar 25, 2024 9:27 pm
by 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.