Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
ARCS - Custom Aging Calculations attribute not working as expected — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ARCS - Custom Aging Calculations attribute not working as expected

Question
22
Views
0
Comments
in Account Reconciliation

Summary:

ARCS - Custom Aging Calculations

Content (required):

We are trying to calculate the aging of Preparers and Reviewers working on the Reconciliations using Custom Attributes as below.

Aging of Preparer = DATE_DIFF({Preparer End Date} ,'TODAY', 'DAYS')

Aging of Reviewer = DATE_DIFF({Reviewer End Date} ,'TODAY', 'DAYS')

 We have defined Workdays as Monday-Friday in Organizational Units and also defined the Holiday rules.

But the Custom Attribute is considering non-work-days (Sat,Sun and holidays) in calculating the age.

Is there a way we can calculate Age excluding non-work days?

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!