Hello,
We have a requirement to calculate exact 48 hours from the current date and time (datetime component) excluding the weekends and holidays. We need to validate this based on the date the user selects.
1) We tried using Appian default function workday() but it calculates only date.
if( ri!date > workday( now(), 2, cons!HOLIDAYS_DATE ), {}, "Please select a Date which is two days in the future" )
2) We also created a Process Calendar provided by Appian but:
Can somebody please suggest a solution ?
Thanks in advance.
Sandra
Discussion posts and replies are publicly visible
From the above link, it is possible to select a single day and set the working hours from 12 am- 11.59 pm. Selection of all the days(M, T, W etc) and setting the working hours from 12 am-11.59 pm is not possible as it considers it as non-working days. Our requirement is such that the entire calendar's working time be from 12 am to 11.59 pm.
FYR,
Selecting all the Wednesdays of the month with working time from 12 am-11.59 pm marks all the selected days as non-working days.
Whereas setting 12 am-11.59 pm as the working hours is possible only by selecting a single day
Is there any way to update the working hours from 12 am-11.59 pm for the entire calendar(except weekends)?
Thanks,
Hi Sandra,
Use <CTRL> key to select all the working days and set the working hours to 12:00 AM to 11:59 PM as follows.
As I could see you had marked 'Mark as non-working days' option. So, the selected days have been assigned as non-working days.
Hope this helps.
Aditya.