businessDay
Syntax
businessDay(X, [offset], [n=1])
Arguments
X is a scalar/vector of data type DATE, DATEHOUR, DATETIME, TIMESTAMP or NANOTIMESTAMP.
offset (optional) is a scalar of the same data type as X. It must be no greater than the minimum value of X. The default value is the minimum value of X.
n (optional) is a positive integer. The default value is 1.
Details
If X is a business day (Monday to Friday), return date(X). Otherwise, return the most recent business day.
If parameter offset is specified, the result is updated every n business days. Parameter offset works only if parameter n>1.
Examples
businessDay(2019.01.06);
// output
2019.01.04
businessDay(2019.01.04);
// output
2019.01.04
date=2019.01.06 + 1..10
businessDay = businessDay(date)
businessDay2 = businessDay(date,min(date),2)
table(date, businessDay, businessDay2);
date | businessDay | businessDay2 |
---|---|---|
2019.01.07 | 2019.01.07 | 2019.01.07 |
2019.01.08 | 2019.01.08 | 2019.01.07 |
2019.01.09 | 2019.01.09 | 2019.01.09 |
2019.01.10 | 2019.01.10 | 2019.01.09 |
2019.01.11 | 2019.01.11 | 2019.01.11 |
2019.01.12 | 2019.01.11 | 2019.01.11 |
2019.01.13 | 2019.01.11 | 2019.01.11 |
2019.01.14 | 2019.01.14 | 2019.01.11 |
2019.01.15 | 2019.01.15 | 2019.01.15 |
2019.01.16 | 2019.01.16 | 2019.01.15 |