Absence duration is not calculating properly when applied in advanced mode.

Summary:

Hi Folks,

Absence Duration is nor calculating properly when applied in advanced mode. It is calculating only . It is deducting only one day. What might be the reason?

Content (please ensure you mask any confidential information):

I am using this below code.

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

23D

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

l_days_between = DAYS_BETWEEN(TRUNC(IV_END_DATE),TRUNC(IV_START_DATE))+1

i = 1

WHILE (i<=l_days_between)/*(TRUNC(IV_START_DATE)<=TRUNC(IV_END_DATE))*/

LOOP

(

l_data = ESS_LOG_WRITE('entered into while loop')