Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Shabbeer Shaik (ShabbeerS)
HCL

HCL
IN
ShabbeerS Member since 2017 2 posts
HCL
Posted: Feb 28, 2018
Last activity: Mar 8, 2018
Posted: 28 Feb 2018 7:29 EST
Last activity: 8 Mar 2018 6:09 EST
Closed

How Can I Calculate the Business hours between the two dates in report definition ?

We have ootb function datediffrence to calculate difference between two dates, but I have requirement that in report definition have to calculate datedifference in business hours only... can any one help me out this.. please

To see attachments, please log in.
User Experience

Posted: 6 years ago
Posted: 28 Feb 2018 13:01 EST
GouriShankar Korivi (GOURI_SHANKAR_K)
de Volksbank
Lead System Architect
de Volksbank
NL

Hi, you can use the below one to calculate in seconds. You can multiply that with 60*60 to convert into hours

RULE-UTILITY-FUNCTION BUSINESSCALENDAR DIFFERENCEBETWEENDATETIMES

Regards

Gouri Shankar K

To see attachments, please log in.
Posted: 6 years ago
Posted: 8 Mar 2018 6:09 EST
Shabbeer Shaik (ShabbeerS)
HCL

HCL
IN

Hi GOURI_SHANKAR_K, Thanks for reply, but it won't work in report definition, actually we have to create function alias with sql query, I have tried but getting errors... I dont know how proper syntax to write sql query in function alias source code.. 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice