Incorrect Date Format in CSV Exported from Data Structure
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.
Comments
-
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.
Howdy, Stranger!
Categories
- 4.4K All Categories
- 82 General
- 13 Training
- 210 Installation / Setup
- 1.2K Flows
- 110 Rules
- 270 Administration
- 213 Portal
- 498 General Q & A
- 714 Forms
- 347 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 187 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 70 Repository
- 230 Integrations
- 29 Multi-Tenant
- 27 SDK
- 81 Modules
- 59 Settings
- 26 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions