Question

Dates are downloaded as random decimals

We needed to do exports and noticed that the dates are coming out as decimals. 

I created an excel report template, went to different leads folders and when downloaded a report, the dates are all decimals. Even with different reports they still export as decimals. 

Therefore is either a problem with the excel report plugin or in the creatio system both I can't modify. 

Please check this out when you can. I think this is a new problem I don't remember having this issue before. 

 

Like 0

Like

1 comments
Best reply

Hello Starlyn,

All you need to do is add formatting as dates to the column where the date values will go in your template. See https://share.customerfx.com/JruOqLb1

Note, if you add that date formatting to the template, it will print correctly with the dates formatted as expected. I have a full video showing how to do this in a template here: https://customerfx.com/video/using-templates-for-excel-reports-in-creat…

Ryan

Hello Starlyn,

All you need to do is add formatting as dates to the column where the date values will go in your template. See https://share.customerfx.com/JruOqLb1

Note, if you add that date formatting to the template, it will print correctly with the dates formatted as expected. I have a full video showing how to do this in a template here: https://customerfx.com/video/using-templates-for-excel-reports-in-creat…

Ryan

Show all comments