Free cookie consent management tool by TermsFeed workday() Function
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
Process Reports Compatible
Process Events Compatible

workday() Function

FEEDBACK