Export to CSV has datetime issues

[Devil Lee]

Hi, I'm trying to export the data from the React scheduler component to csv following the sample from  Exporting in React Schedule component | Syncfusion, but the sample export causes the datetime to be this format  "30/6/2019 9:30 A1/P1" when the export type is csv, but is in normal datetime format when exported in .xslx

How do I convert the datetime format to be something like 11/18/2022 12:00 AM instead when exporting to csv? thank you.

[Ram Raju Elaiyaperumal]

Hi Devil Lee,

Your reported problem “Exporting to CSV from Excel caused a datetime format issue" is considered a bug. The fix for this defect will be included in our upcoming weekly patch release, which is expected to be rolled out by June 25, 2023. You can track the status of the fix at the following link:

 

Feedback : https://www.syncfusion.com/feedback/58849/exporting-to-csv-from-excel-caused-a-datetime-format-issue

 

Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.

 

Regards,

Ram.

[Vijay Ravi]

Hi Devil Lee,
 

Thanks for your patience.

We are glad to announce that our patch release (V26.1.39) has been rolled out successfully. The issues with the “ Exporting to CSV from Excel caused a datetime format issue" have been resolved in this release. To access this fix, we suggest you update the package to 26.1.39.

Regards,

Vijay

Attachment: export_to_csv_198d9ec2.zip