workday() Function

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
Sync-Time Custom Record Fields	Compatible	Can be used to create a custom record field that only evaluates at sync time.
Real-Time Custom Record Fields	Incompatible	Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.
Process Reports	Compatible
Process Events	Compatible

Feedback