How to pass hours as 2nd parameter in caladdddays function

Hi All,

In my  application, I have to use caladddays() function which calculates only the net work days and for daylight boundaries.

So for 72 hours, I will use caladddays(ri!date,3) ,  it works fine.(where ri!date = 1st November 2021,10:00 AM)

But the user wants to pass the 2nd parameter by constant and he wants to test for 1 hour by changing the constant value.

If I use caladdhours,the outputs are different  from caladddays, PFA the below screenshots,

If there is anyway to pass hours in caladddays function, can you please help me?

Thanks in advance.

Regards,

Jansi J

  Discussion posts and replies are publicly visible