$addyears

$addyears

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

$addyears

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

Syntax

$addyears(date,number)

Parameters

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

Return Value

Number, representing a DATE value.

Comments

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

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

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

Example

If $Date has the value 19981225, then

$addyears($date,5)

Evaluates to 20041225.

$addyears($date,-5)

Evaluates to 19931225.

$addyears(19980229,1)

Evaluates to 19990228.

See Also

$adddays

$addmonths

$addweeks

$todate

$weekday

$year

+ (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%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish