Workdays

Calculates a duration in work days between start and snd dates inclusive.

Variants

Workdays(Date start, Date end)

Calculates a duration in work days between start and end dates inclusive.

Parameters

start
The date to start.
end
The date to end.

Returns

Duration

Remarks

Weekends are calculated and subtracted based on the "Weekends" property value from database properties (with Saturday and Sunday as the default weekend).

Examples

Workdays(Date start, Date end, Text weekends)

Calculates a duration in work days between start and end dates inclusive, given the weekends specified by third argument.

Parameters

start
The date to start.
end
The date to end.
weekends
The Weekends argument is a string specifying either one or two digits in a 1…7 range to specify the first and second weekends starting from Monday (1) to Sunday (7), or a "bitmap" consisting of exactly seven zeroes and ones, indicating whether the day is a weekend (1) or not (0). For example, classic Saturday-Sunday weekends can be represented as either "67" or "0000011".

Returns

Duration

Examples