how to derive fiscal year from start date

[jd]

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,

[melee]

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?

[jd]

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

[melee]

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?