Does anyone have a solution on how to create Excel reports with Time type columns? I tried to use "Excel reports builder" but it gave me an error "Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.Couldn't store <00:39:00> in ___ Column. Expected type is DateTime." I want to make a pivot table and graph, so the usual unloading of the registry is not enough for me. 

Like 0

Like

5 comments
Best reply

Hello,
The current version of the Excel reports builder for Creatio app doesn't support Date / Time formats. The responsible team plans to add...MoreLess

Show all comments (4)

Hi community,

I have a time column typed named Duration. In the execution of a business process I want to change the value of this attribute with the difference of two datetime parameters: enddate - startdate. Is there any way to perform this action or should I change the type of this column to type number.

Like 0

Like

0 comments
Show all comments

We have Creatio in the cloud, the server has 6 or 7 hours difference from my local time. I don't know if switching to summer/winter time in my country affects the difference. To get the current time, I should calculate it. Or I have to go to Process Log and look upon the latest processes time. Is there a way to easily get the current server time?

Like 0

Like

1 comments

Hello Yuriy, 



The current DB and server time is set to UTC+0 no matter where the website is located. 

Please note, that you can always...MoreLess

Show all comments