When Using a Date Field with a Formula That Calculates the Number of Days Between Start Date and Finish Date the Number of Days Displayed Is Incorrect (Doc ID 2885712.1)

Last updated on SEPTEMBER 29, 2022

Applies to:

Symptoms

When processing a Business Process (BP) record for "BP-1", there is a data element called "DE1" which is configured with a formula that takes the Date Difference between "Finish Date" and "Start Date" fields and displays this difference based on "Calendar Days". Per the Unifier Documentation this should be selected to get the desired functionality that is desired: "Choose Calendar Days to include all the days of the week in the calculation". However in this example, the Start Date is on a Sunday and Finish date is on Tuesday. After the dates, the calculation is 2 but after saving the Line Item the calculation is 1 which is not expected by user.


EXPECTED BEHAVIOR
----------------------------
When using "Calendar" days setting in Date Difference formula, the calculated difference should take into account ALL days whether working days or not.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Log into the Unifier environment.
2. Navigate to the project/shell where the issue has been observed.
3. User Mode > BP "BP-1" > Open an existing or create a new record > Line Items > Add a line item > For Start Date picker select today's date and for Finish Date select a date in two days.  Note that the date difference is 2 as expected.
4. Save the line item > Notice that now the date different is 1, which is incorrect.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.