We help IT Professionals succeed at work.

How do I create a fiscal year filter for a report in Cognos 8.4

Aslan_rules
Aslan_rules used Ask the Experts™
on
I need to create a dynamic fiscal year filter for Cognos 8.4 report. Fiscal year runs from Oct 1 to Sep 30.
My hard coded existing code is: [DEV].[Commitment Oblig2].[Award Date] between to_date( '01-10-2009 00:00:00',
'dd-mm-yyyy hh24:mi:ss') and
to_date( '30-09-2010 00:01:00','dd-mm-yyyy hh24:mi:ss')
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2012
Commented:
given any date, v_date,  the beginning of that date's fiscal year will be...


add_months(trunc(add_months(v_date,3),'yyyy'),-3)


the end of the fiscal year  will be


add_months(trunc(add_months(v_date,3),'yyyy'),9)-1

Author

Commented:
v_date is current_date in Cognos, thanks