DateAddWorkdays

EAZYBI 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.

If Time dimension options are specified then these Time dimension non-working days will be used (in this case please do not specify this argument).

Examples

DateAddWorkdays([Issue].CurrentMember.get('Created at'), 5)

DateAddWorkdays([Issue].CurrentMember.get('Created at'), 5, '67')

See also

DateAddDays