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

Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.

Process Reports Compatible
Process Events Compatible
Open in Github Built: Thu, Jun 13, 2024 (05:08:43 PM)

workday() Function

FEEDBACK