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.
Hello, The current version of the Excel reports builder for Creatio app doesn't support Date / Time formats. The responsible team plans to add this feature in the next app release. A new version will become available in July.
Unfortunately, it doesn't work with Duration. A report with Time-format columns (00:00:00) is not creating. So I thought maybe there was another solution
Hello, The current version of the Excel reports builder for Creatio app doesn't support Date / Time formats. The responsible team plans to add this feature in the next app release. A new version will become available in July.
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.
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?
