Related content:

Question Function Alias to calculate difference between Business Calendar Days Question Business days calculation using Function alias in Report definition Question Calculate difference in business days using function alias in Report Definition. Question Calculate difference in business days using function in Report Definition Discussion Business days difference in Report definition rule Question Report Definition - Function Alias - The difference in days - to get the outputs in decimal instead of rounded down to nearest day Question Business calender in the function Question Funaction Alias to calculate difference between Business Calendar Days Question Business calender Function issue Question We need to calculate the difference between two dates to get the output as ‘10 days 12 hours 25 minutes 2 seconds’ using the Function Alias rule.

Question

3
Replies
3242
Views
SVAQuest Member since 2012 87 posts
Tata Consultancy Services Ltd
Posted: 2 years ago
Last activity: 2 years 7 months ago
Closed

Report Definition - Function Alias - The difference in days - to get the outputs considering the business days that are configured in the Calender

Hi All,
Function: The difference in days between .pxCreateDateTime and .pyResolvedTimestamp
Function Description: Returns the difference between two Date or DateTime values (the second minus the first) in days, rounded down (rounded for ORACLE) to the nearest day

Currently the function is working as expected, but how to get the difference in days including the business days that had been configured in business Calender?
Any Suggestions?

Case Management Data Integration
Close popover
Moderation Team has archived post
Posted: 2 years ago

Hi SVAQuest,


You can use the below function to implement your requirement:

 




Library Name

Function Name

Ruleset

Label

DateTime

differenceBetweenDays

migrated from BusinessCalendar:Pega-RULES

Number of business or calendar days between two Dates

 


Hope this helps!


Regards,

Evita.

Posted: 2 years ago

Hi Evita,


Guess we would need a Embed-SQL function to calculate the difference in a Report Definition.
Share this page LinkedIn
Copied!