Hi Rohitsud,

I'd like to help but I'm not sure what your request is. Please express your request in the form of a question. Which control are you referring too and in what context are you using it?

Regards,

Henry

Pega Academy

Hi Henry

In my list view, i have a fields that is a difference of 2 date/times so its time, not a date. 

I gave the format and export format both as TimeElapsed-HMS because I want it to show as hh:mm:ss.

It shows as expected on screen but when exporting to excel, the column gets converted to hours.

I need to manually change the format of the column to [h]:mm:ss.

Interestingly, if i try the same thing in a summary view, it works fine. i.e.even in the excel export, it shows as hh:mm:ss so I am not sure if its a Pega issue or excel.

thanks for the help.

Rohit

What is the type of the property that you are applying the control to?

Regards

Emilio

Its a date/time property.

Regards

Rohit

This should work and is likely a bug.  You should contact customer support to see if a solution exists for it.

Regards

Emilio

Hi Rohit,

As a work around, try creating a new Property of Data Type Time and use a Declare Expression to compute the difference between the two DateTime Properties in your example. Then use the new Property in the Report in lieu of the current configuration.

Regards,

Henry

Pega Academy