Question
3
Replies
3389
Views
Posted: November 27, 2017
Last activity: December 28, 2017
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?
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Hi Evita,
Guess we would need a Embed-SQL function to calculate the difference in a Report Definition.
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.