workday() Function
This function may not be compatible with all features of Appian. For details, see the Feature Compatibility section below.

Function

workday( starting_date, days, holidays )

Returns the date the given number of workdays before or after the given date.

Parameters

Keyword Type Description

starting_date

Date

The starting date.

days

Integer

The number of days to advance into the future (positive numbers) or days to retreat into the past (negative numbers).

holidays

Date

A list of holidays not counted as workdays.

Returns

Date

Usage considerations

An array of holidays may be given by enclosing them in braces, such as {"12/25/2004","12/31/2004"}.

Examples

workday(date(2011,12,13),-6) returns 12/5/2011

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Compatible
Offline Mobile Compatible
Custom Record Field Expressions Compatible
Open in Github Built: Fri, Aug 05, 2022 (02:40:39 PM)

On This Page

FEEDBACK