cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting wrong date format to EXCEL from smart table

0 Kudos
1,979

HI,

I am having a date column field in the smart table and it is in the format of dd-mm-yy.

In responsive smart table, while exporting the table to into excel using standard export option of smart table, the date column data is exporting in the format same as which is coming from back end.(/12121997)

Please help.

Accepted Solutions (0)

Answers (2)

Answers (2)

HI,

I have and extended column with date, but after giving type property as date, it was working.

<core:CustomData key="p13nData" value='\{"columnKey": "Callback", "sortProperty": "Callback","filterProperty":"Callback","columnIndex":"7", "leadingProperty": "Callback", "type":"date"}'/>

I could only find the answer

Joseph_BERTHE
Active Contributor
0 Kudos

Hi,

It's seams that your attribute date is not a timestamp. Please do the correction in the OData service.

Regards,

Joseph