Hello, I am having some difficulty getting my time stamps to retain the right format when exported from power table to .csv. I am using the following script on button press: exp = event.source.parent.getComponent('ExportLog').data sDate = system.date.now() fsDate = system.date.format(sDate,"yyyy_M…

You could change the column on excel, Format cells, and try either date or just text type Edit: Or use this on excel? You can then not detect data type [image]

Issues With Time Stamp Format Upon Export to .CSV

Ignition

JordanCClark August 24, 2023, 3:10pm 7

Using the POI libraries, you can format the dates however you want. Don't let the thread title fool you. I have scripts in there for both directions.

6 Likes