Print Page - how to derive fiscal year from start date

Title: how to derive fiscal year from start date
Post by: jd on 25 Feb 2011 11:40:25 AM

Hi,

I have start date column in my package.
ex: start date = Jan 7, 2005 12:00:00 AM

I need to create colum for fiscal year.
for ex FY2005= start between Sep 30, 2004 and Oct 01 2005

I tried with to_char and to_date functions. but got error.

any Idea how to get it
I have to filter my report on fiscal year only, which I do not have in the package directly.

Thanks,

Title: Re: how to derive fiscal year from start date
Post by: melee on 25 Feb 2011 12:12:55 PM

Just for clarification - are you trying to add a column that displays the FY, or are you trying to create a filter/prompt that's like so: FY2005 filters Sep 30 2004 through Oct 01 2005?

Title: Re: how to derive fiscal year from start date
Post by: jd on 25 Feb 2011 12:16:00 PM

Hi Melee,

thanks for your quick reply,

I am tring to create a filter/prompt:
that's like FY2005 filters Sep 30 2004 through Oct 01 2005

Title: Re: how to derive fiscal year from start date
Post by: melee on 25 Feb 2011 01:53:01 PM

Quote from: d.laxmi on 25 Feb 2011 12:16:00 PM
Hi Melee,

thanks for your quick reply,

I am tring to create a filter/prompt:
that's like FY2005 filters Sep 30 2004 through Oct 01 2005

One more question - you are going to pull the FYs from the database, or have a static prompt?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 25 Feb 2011 11:40:25 AM