Hi all. I have created some custom reports and exported them as xlxs. I am looking at the DATE data from Creatio objects that appear in the xlxs files.
- What is the format used in the Date fields ?
- What MS Excel function will display this data in a human readable format?
Like
Hello Charles,
What you need to do is create a template for the Excel report. In the date columns, you can add cell formatting in any date format you'd like. Then upload the template for the Excel report and from then on the report will use the date format you specified in the template. I have a video tutorial of how to do this here: https://customerfx.com/video/using-templates-for-excel-reports-in-creat…
Ryan
Hello Charles,
What you need to do is create a template for the Excel report. In the date columns, you can add cell formatting in any date format you'd like. Then upload the template for the Excel report and from then on the report will use the date format you specified in the template. I have a video tutorial of how to do this here: https://customerfx.com/video/using-templates-for-excel-reports-in-creat…
Ryan