Question

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?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

Pega
November 27, 2017 - 11:24pm

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.

November 28, 2017 - 12:48pm
Response to Evita_08

Hi Evita,

Guess we would need a Embed-SQL function to calculate the difference in a Report Definition.

December 28, 2017 - 4:35am