Hi All,
I want the output of a workday function to be Date&Time instead of just Date. Please advise on how I can wrap the below logic to get the output as Date& Time:workday( todatetime("01/01/2024 7:01 AM"), ( dayofyear( caladddays(todatetime("01/01/2024 7:01 AM"), 0, "Default Calendar") ) - dayofyear(todatetime("01/01/2024 7:01 AM"))),datetime(2024,01,01) )I need the output to be 1/2/2024 7:01 AM instead I just get 1/2/2024.
Discussion posts and replies are publicly visible
What are you trying to do exactly?
Hi Mathieu, I have a scenario where if an expected SLA date&time falls on a non-working day, I need to get next working day value.For example, I have my initial submitted date as 12/27/2023 2:01 PM PST and expected SLA date time based on some biz logic should be 1/2/2024 7:01 AM PST. I have used the below logic but somehow instead of getting the SLA date result for next year as 1/2/2024 7:01 AM PST, I am getting the SLA date result in the same year as 1/2/2023 7:01 AM PST.Please note correct process calendars are used and Dec 30 2023, Dec 31 2023 and Jan 1 2024 are all set as non-working day in the calendar.Please help/advise on how I can update to get the correct value: ( I tried using workday but it returns just date and not datetime)local!finalSLADateTime:if(calisworkday(1/1/2024 7:01 AM PST, local! Calendar),1/1/2024 7:01 AM PST,1/1/2024 7:01 AM PST + (dayofyear(caladddays(1/1/2024 7:01 AM PST, 0, local! Calendar)) - dayofyear(1/1/2024 7:01 AM PST))),
As an approach treat the date and time as separate components. From your original value you an extract the date and time as separate values.
The apply your workday() function to the date component and then use the new date and old time components to generate a datetime value.
If you're still stuck ask.
1. You should be using https://docs.appian.com/suite/help/23.3/fnc_date_and_time_adddatetime.html rather than caladddays which has been deprecated.
2. a!addDateTime() should already return a date time on a working day according to the process calendar that you pass to it. Not sure why you would need to use workday() in addition to that.