Document toolboxDocument toolbox

Support center for flex.bi version 4.0

DateAddWorkdays

Returns date plus specified number of workdays.

Syntax

DateAddWorkdays(date, days)
DateAddWorkdays(date, days, nonworkdays)

Arguments

dateDate expression.
days

Integer expression for number of working days to add.

By default Saturdays and Sundays are considered as non-working days.

nonworkdays

Specify string with non-working day numbers (use 1 for Monday, 2 fort Tuesday, 3 for Wednesday, 4 for Thursday, 5 for Friday, 6 for Saturday, 7 for Sunday).

If not specified then '67' is used which means Saturday and Sunday.

Examples

DateAddWorkdays([Invoice].CurrentMember.getProperty('Invoice date'), 5)
DateAddWorkdays([Invoice].CurrentMember.getProperty('Invoice date'), 5, '67')

See also

DateAddDays