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?
Date formatting Issue in CSV Export
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Date formatting Issue in CSV Export
Hello,
We couldn't reproduce the issue.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
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
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.
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.
Re: Date formatting Issue in CSV Export
Hi Lech,
The version that we are using is 2022.4.5. May be the issue is in that version?
The version that we are using is 2022.4.5. May be the issue is in that version?
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Date formatting Issue in CSV Export
Hello,
Excel itself may not display it correctly.
If you open the file in the editor, the date is correctly written there.
Thank you.
Excel itself may not display it correctly.
If you open the file in the editor, the date is correctly written there.
Thank you.
- Attachments
-
- 1.png (95.03 KiB) Viewed 791 times