Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

  • No labels