Date format in export is in different format

Daniel joseph_by8kle

Hi Team, 

I have created a confiform and once the data is loaded. we have a preexisting column "Created" and using it in Tableview and it shows the date when the record was created. when i export that data from the table to CSV or XLS , the date format is showing some numbers and unable to convert. 

Date shows in Tableview : Aug 16, 2021 15:42

Date shows in export : 1629092565258

Need help please. 

Thanks 

Alex Medved _ConfiForms_

Hi

I believe the question is about ConfiForms and it's export from TableView macro (added "confiforms" tag to question)

 

Data for date/date time fields is exported as timestamp, unless configured otherwise.

https://wiki.vertuna.com/display/CONFIFORMS/Data+Export+tricks+and+hints

 

See this parameter in particular: https://wiki.vertuna.com/display/CONFIFORMS/Data+Export+tricks+and+hints?preview=/8159460/72091226/export-fields.png 

 

Using formatDate virtual function on your date field could help you to transform the output of a date field as you need

Alex