Table of Contents

, ,

BUSINESS_DAY_FORWARD

Description

Calculates the date that corresponds to the first business day after the provided date. Business days are usually those that do not include weekends and public holidays. The list of public holidays may be provided in the PublicHolidays property of the server property file.

Syntax

BUSINESS_DAY_FORWARD (date[, days])

Cannot be used in the condition of a FIND action.

Parameters

Attribute of the Date type or date constant or calculation producing a date. The second parameter is optional – it indicates the number of days to move forward. If omitted, one day is assumed.

Returns

Date: the business day after the given date; with days, that many business days forward (default 1). Weekends and the public holidays in the server's PublicHolidays property are skipped

Example

IF CURRENT_DATE = BUSINESS_DAY_FORWARD (Account.OpeningDate) THEN ... 

BUSINESS_DAY_BACK, DATE_ADD, DAY_NUMBER_IN_WEEK