'Extract year from cognos report expression

I want to extract current year, last year in report expression field but am not able to get it. date2timestamp(Today()) and Today() This works fine to get date

_add_years(date2timestamp(Today()),1) and extract("year",Today()) but this shows error. I wanted to show 2016, 2015 dynamically in my report as heading of cross-tab node.

cognoscognos-10cognos-bicognos-8


Solution 1:[1]

If you use layout calculation try

substring(date2string(Today()),1,4)

for current year. And

string2int32(substring(date2string(Today()),1,4)) - 1

for previous year.

Solution 2:[2]

for current year: extract('year', date2timestamp(today()))

for prior year: extract('year', _add_years(date2timestamp(today()), -1))

This will give you an integer value that you can format using the normal Data Format options in the date item properties, for example to remove the thousands comma if desired.

Solution 3:[3]

Make a query with two data items.

For the previous year, one data item will have:

extract (year, _add_years(current_date, -1))

And for the current year: 

extract (year, current_date).

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Tethera
Solution 3 AlwaysLearning

Related Questions