business()

Scalar. Determines the next business day from a date value, based on a specified offset.

Syntax

business ( calendarfile, datevalue, offset )

Parameters

calendarfile

A string representing the file path for a calendar file.

datevalue

A date/time type.

offset

A negative or positive integer (should not be zero).

Usage

The function returns the same datatype as the datevalue argument.

The offset argument can be any negative or positive integer, but it cannot be zero. The function returns NULL if the offset is zero, and logs an error message. Negative integers return previous business days.

Example

business('/cals/us.cal',v.TradeTime, 1) returns the next business day within the calendar us.cal after the TradeTime date.