# Dataset export to Excel datetime conversion issue

**URL:** <https://forum.inductiveautomation.com/t/dataset-export-to-excel-datetime-conversion-issue/33617>\
**Category:** Ignition\
**Tags:** ignition80, scripting\
**Created:** [April 2, 2020, 6:43am UTC](https://forum.inductiveautomation.com/t/dataset-export-to-excel-datetime-conversion-issue/33617 "2020-04-02T06:43:40Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![guganathan.r](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@guganathan.r](https://forum.inductiveautomation.com/u/guganathan.r)\
**Post date:** [August 22, 2020, 8:14am UTC](https://forum.inductiveautomation.com/t/dataset-export-to-excel-datetime-conversion-issue/33617/5 "2020-08-22T08:14:41Z")

</div>

Sorry I couldnt get as required.

Table JSON is converted to dataset and I used system.dataset.formatDates as suggested. But no conversion. I still get in unix milliseconds timestamp.

```
data = self.parent.parent.getChild("TableConsumption").props.data

# TableEXPORTFIELDCHOOSER is a custom made table for users to choose the columns and order of column to export.
tablefieldds = self.getSibling("TableEXPORTFIELDCHOOSER").props.data
sorttablefieldds = system.dataset.sort(tablefieldds, 2)

#Get the chosen columns	
tablefieldheader = []
for row in range(sorttablefieldds.rowCount):
	if sorttablefieldds.getValueAt(row, "CHOOSE") == True:
		tablefieldheader.append(sorttablefieldds.getValueAt(row, "COLUMNS"))
	
system.perspective.print(tablefieldheader)
system.perspective.print(len(tablefieldheader))

tpc = self.parent.parent.getChild("TableConsumption").props.columns
newheader = []

#Get the field name for columns		
for title in range(len(tablefieldheader)):
	for row in range(len(tpc)):
		if tablefieldheader[title] == tpc[row]["header"]["title"] :
			tpcfield = tpc[row]["field"]
			newheader.append(tpcfield)
system.perspective.print(newheader)
system.perspective.print(len(newheader))

#convert JSON table output to dataset	
datasetData = []
for row in range(len(data)):	
	rowData = []
	for col in range(len(newheader)):
		cell = data[row][newheader[col]]
		if hasattr(cell, 'value'):
			rowData.append(cell.value)
		else:
			rowData.append(cell)
	#system.perspective.print(rowData)
	datasetData.append(rowData)

#export to excel	
finalDataset = system.dataset.toDataSet(tablefieldheader,datasetData)
formatdateds = system.dataset.formatDates(finalDataset, "dd-mm-yyyy")
XLSFormat = system.dataset.dataSetToExcel(True,[formatdateds], True)
timenow = system.date.format(system.date.now(), 'dd_MM_yyyy_HH_mm')
filename = 'T2_SHIFTPARAMS_' + timenow + '.xls'
system.perspective.download(filename,XLSFormat)

```

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/b/0bef94a31822313f838217e3748d258ddb4dfc20.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/4/14870bb2f6aaa6948c32300dfffdc8701ff06585.png)

---

_[View the full topic](https://forum.inductiveautomation.com/t/dataset-export-to-excel-datetime-conversion-issue/33617)._