613-518-1166 info@zimdatabases.com

ZIM Language Reference


< All Topics


Calculates a date value by adding weeks to (or subtracting weeks from) a specified date value.





a date, or an expression that evaluates to a DATE data type


a number, or an expression that evaluates to a number

Return Value

Number, representing a DATE value.


Use $addweeks to perform arithmetic with date values. The $addweeks function calculates a date value by adding a number representing weeks to a date value. If number is negative, the effect is to subtract the weeks from the date.

The + (add) and – (subtract) operators can be used to achieve the same results.

If date or the result of the $addweeks expression is an invalid date (e.g., 19930231), it is adjusted to produce a valid date (e.g., 19930228).


If $Date has the value 19981225, then


Evaluates to 19990101.


Evaluates to 1998.501.


Evaluates to 19980301.


See Also






+ (Add/Positive)

– (Subtract/Negative)

About Functional Expressions

Arithmetic with Dates

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents