Dear community,
Every time we try to create an excel report with a time field we get the following error:
Does anyone know how to solve this problem?
We are currently working on 7.18.
Thank you in advance!
Kind regards,
Yosef
Like
Hi Yosef,
Set the Time type for the specified column in the .xlsx template file and upload it to the report settings.
Hope this helps.
Yosef,
I have a video demonstration of how to use a template with column formatting with an Excel report here
https://customerfx.com/video/using-templates-for-excel-reports-in-creat…
Hope this helps with knowing how to add formatted columns to the template.
Ryan
Hi Yosef,
The details are on the screenshot below. Select the 'Start' column and set the required cell format. Then, save the .xlsx template file and upload it to the report settings.
Ivan Leontiev,
Thank you both for the information.
I followed the steps Ryan gave me (very helpful!) and I changed the settings like you asked but I still get the same error:
Any idea?
Kind regards,
Yosef
Hi Yosef,
We have reproduced the issue and submitted it to the responsible team. I'll keep you updated.
Hi Alexander,
Do you please have an update for us? The customer is getting impatient... We need to fix this problem.
Regards Sandra
Hi Sandra,
It is not possible to export fields of "Time" type with the app at the moment. However, the team in charge is planning to add this feature this month.
Ivan Leontiev,
Hello
Thanks for the information above. it was insightfull and helpful.
I am trying to export a time format field - and as it seems - it is not possible, and i get an error message.
Is there any workaround for this issue ?
herein the error message that i get: 
Hi Aluma,
Could you please attach the error message again as we are unable to view it?
Best regards,
Anastasiia