COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: krishdw85 on 26 Mar 2024 07:27:38 AM

Title: how to display ... product age years instead of date
Post by: krishdw85 on 26 Mar 2024 07:27:38 AM
It has been longtime since I have working on date functions. how to display product age as no of years .

Thanks in advance for your help.

A-B=C

In C i have to show the product age in years
Title: Re: how to display ... product age years instead of date
Post by: bus_pass_man on 26 Mar 2024 08:07:42 AM
They are where they always were, in business date/time functions. 

You have a fair number of functions such as years between ymdint between, and age.

Title: Re: how to display ... product age years instead of date
Post by: krishdw85 on 26 Mar 2024 08:44:19 AM
-years_between worked very well.....