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.


Jansi J

  Discussion posts and replies are publicly visible