Cognos - Report Functions

There are various Report functions that can be used in a Cognos report.

Some of these different report functions include −

_days_between

This function is used to return a positive or a negative number representing the number of days between the two datetime expressions. If a timestamp_exp1 < timestamp_exp2 then the result will be a –ve number.

How to use

_days_between(timestamp_exp1, timestamp_exp2)

_days_to_end_of_month

This function is used to return a number representing the number of days remaining in the month represented by the datetime expression timestamp_exp.

How to use

_days_to_end_of_month(timestamp_exp)

_first_of_month

This function is used to return a datetime that is the first day of the month represented by timestamp_exp.

_add_days

This function is used to return the datetime resulting from adding integer_exp days to timestamp_exp.

How to use

_add_days(timestamp_exp, integer_exp)

_add_months

This function is used to return the datetime resulting from adding integer_exp months to timestamp_exp.

How to use

_add_months(timestamp_exp, integer_exp)

_add_years

This function is used to return the datetime resulting from adding integer_exp years to timestamp_exp.

How to use

_add_years(timestamp_exp, integer_exp)

_age

This function is used to return a number that is obtained from subtracting timestamp_exp from today s date in YYYYMMDD format (years, months, days).

How to use

_age(timestamp_exp)

_day_of_week

This function is used to return the day of week (between 1 and 7), where 1 is the first day of the week as indicated by integer_exp (between 1 and 7, 1 being Monday and 7 being Sunday). Note that in ISO 8601 standard, a week begins with Monday being day 1. In North America where Sunday is the first day of the week being day 7.

How to use

_day_of_week(timestamp_exp, integer_exp)

_day_of_year

This function is used to return the ordinal for the day of the year in date_ exp (1 to 366). Also known as the Jupan day.

How to use

_day_of_year(timestamp_exp)

Like these, there are various other Report functions as well that can be used.