Trouble with timestamp not showing properly in exported CSV

Ignition
1

I have a table of data:

JDE_Label, LPN_Label, timestamp…

C1234567800002, 11824022, Dec 8 2014 1:21 PM
C1234567800003, 11824024, Dec 8 2014 1:18 PM

When exported to CSV then imported back to Excel the timestamp column looks like

2014-12-8 0:00
2014-12-8 0:00

Where did my time go? Is there something additional I need or a different format for the original timestamp column??

table = event.source.parent.getComponent('Table').data system.dataset.exportExcel("verify_data.xls", 1, table)

Thanks

2

exportExcel ouputs an XML file. Since that’s just a formatted text, we can take a closer look. :thumb_left:

Open the file in a text editor. Notepad will do, but Notepad++ is my favorite child.
Here’s a shot from one of mine. My example comes out in 24h time, but you can compare and see if the full datetime is at least getting that far.

2014-12-08_14-42-47.png782×381 23 KB