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.
Discussion posts and replies are publicly visible
caladddays(ri!date,3)+ cons!EXA_HOURS_ADDITONAL * hours()
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 .
then i missunderstood you.
are you looking for additional working hours on top of your datetime?
jansij0001 said:pass hours constant .
I am not sure if we talk about the same sense of "constant" here.
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.
© 2022 Appian. All rights reserved.