Issue in TimeElapsed-HMS control in export extract
This control is exporting time in hours even though in the list view report, it shows in hh:mm:ss format and same control is used for format and export format columns.
For reference, Pega 6.1 was used.
Pegasystems Inc.
US
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
Cognizant
US
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
Pegasystems Inc.
US
This should work and is likely a bug. You should contact customer support to see if a solution exists for it.
Regards
Emilio
Pegasystems Inc.
US
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