Question

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

cons!EXA_HOURS_ADDITONAL(type: int)

caladddays(ri!date,3)+ cons!EXA_HOURS_ADDITONAL * hours()

Hi Richard,

Thank you for your reply.

I tried this but it is not working.

caladddays(ri!date,3),here 3 is number of days ,but in place of 3 I want to pass hours constant .

Hi jansij,

then i missunderstood you.

are you looking for additional working hours on top of your datetime?

pass hours constant .

I am not sure if we talk about the same sense of "constant" here.

kind regards,

Richard

Brainy

You can not add hours using the caladddays() function. If you need to use hours, then think in business hours. By default, 8 hours would be one day.

Okay, I got your point. Thanks for your reply.

Sign up