IBM Cognos - Page 373

Add-Days
Returns a datetime value resulting from adding a number of days to a date.
Syntax
add-days (date_exp | datetime_exp, integer_exp)
Examples
add-days (today(), 10)
Returns the result: 03/30/2007 00:00
add-days (today(), -10)
Returns the result: 03/10/2007 00:00
Add-Months
Returns a datetime value resulting from adding a number of months to a date.
Syntax
add-months (date_exp | datetime_exp, integer_exp)
Examples
add-months (today(), 10)
Returns the result: 01/20/2007 00:00
add-months (today(), -10)
Returns the result: 05/20/2007 00:00
Add-Years
Returns a datetime value resulting from adding a number of years to a date.
Syntax
add-years (date_exp | datetime_exp, integer_exp)
Examples
add-years (today(), 10)
Returns the result: 03/20/2017 00:00
add-years (today(), -10)
Returns the result: 03/20/1997 00:00
Age
Returns age as a month-day-year interval by subtracting a specified date from
today's date.
Syntax
age (date_exp | datetime_exp)
Example
age (1996-08-19)
Returns the result: 02/01/0002 00:00
Appendix F. IBM Cognos Transformer Expression Editor 359