How to get end of business day date and time based on appian process calendar

Question

How to get end of business day date and time based on appian process calendar? Kindly help me with this, Thankyou

Harsha Sharma · Accepted Answer

AFAIK there is no function to get the data saved in a process calendar. If you want to retrieve the value and then compare against something/ store somewhere then that part is not possible. 
 If you need to apply some conditions based on it, the below functions can be used to create evaluation expressions and have the system perform the checks. 
 
 a!addDateTime() 
 a!subtractDateTime() 
 calisworkday() 
 calisworktime() 
 calworkdays() 
 calworkhours() 
 
 E.g. if you want a process to run only within the work hours added in calendar then in condition you can use the below expression and process will not trigger outside business hours. 
 calisworktime(now(),calendar_name) 
 Let me know if you are looking for a specific scenario otherwise hope this helps!

Shubham Aware · Answer

No direct function to retrieve the configuration data stored in a process calendar. You can check if a time is working time using calisworktime() https://docs.appian.com/suite/help/25.2/fnc_date_and_time_calisworktime.html You can simply hardcode business hours in constants or database tables since calendar configurations can't be accessed programmatically in Appian. This gives more control to you.

Mathieu Drouin · Answer

This old thread might be helpful 
 community.appian.com/.../hi-is-there-a-way-to-get-the-end-of-business-hours-for-a-day-from-a-calend

amitm9 · Answer

Please set the specific calendar if your scenario is not fulfilled with default calendar and then use below Appian functions in your rule.
calisworkday( datetime, calendar_name) and
calisworktime(now(),calendar_name)

How to get end of business day date and time based on appian process calendar

Top Replies