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
Custom Record Field Expressions Compatible
Process Reports Compatible
Process Events Compatible
Open in Github Built: Thu, Apr 18, 2024 (09:37:34 PM)

workday() Function

FEEDBACK