Skip to main content
July 15, 2025
Solved

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

  • July 15, 2025
  • 4 replies
  • 0 views

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

    Best answer by harshas2775

    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. 

    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! 

    4 replies

    harshas2775
    July 15, 2025

    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. 

    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! 

    shubhama926776
    July 15, 2025

    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. 

    mathieud0001
    July 15, 2025
    amitm956894
    July 15, 2025

    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)