Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Returns date plus specified number of workdays.

Syntax

Code Block
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

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

...


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

See also

DateAddDays