Incorrect Date Format in CSV Exported from Data Structure

kimjohn

In the data structure, we have a DateFormat field (yyyy-MM-dd HH:mm:ss.fff) stored as a string in the database. When exporting the data to a CSV file by right-clicking the data structure and selecting Import/Export Data --> Export Data To CSV, the date format of that column changes when opening the CSV file in Excel or Google Sheets. However, when opening the CSV file in Notepad or Notepad++, the date format remains the same as it was saved in the data structure.

amershaik_Decisions

This is expected behaviour, since Notepad or Notepad++ displays the file in a raw format.

However, in the case of Excel or Google Sheets, it depends on how they handle the data.

To display the date as expected in Excel or Google Sheets, you need to format the date column to the required date format.