Function Reference > Dates > Understanding date arithmetic

Understanding date arithmetic

The transformation language provides built-in date functions so you can perform arithmetic on datetime values as follows:
You cannot use numeric arithmetic operators (such as + or -) to add or subtract dates.
Data Integration recognizes leap years and accepts dates between Jan. 1, 1753 00:00:00 AD and Dec. 31, 9999 23:59:59 AD.
Note: Data Integration uses the Date/Time datatype to specify date values. You can only use the date functions on datetime values.