Operator Type:
Operator Scope of Action:
Operator Purpose:
Data Type Returned:
Operator First Added:
Operator in Current Baseline:
Operator Last Altered:
Function [other Function type actions]
Item [operators of similar scope]
Date-time [other Date-time operators]
Number [about Number data type]
v7.5.0
Baseline
As at baseline
weeks(startDate, endDate)
This returns the Number of (7-day weeks) weeks between two dates, startDate and endDate. If the dates are within seven days of each other, the result is zero.
If $DateA is 3 January 2016 and $DateB is 20 January 2016, then:
$MyNumber = weeks($DateA,$DateB); sets $MyNumber to 2.
If endDate is before startDate the result is negative.