Home » Developer & Programmer » Reports & Discoverer » Discoverer - change of year periods
Discoverer - change of year periods [message #88543] Thu, 07 November 2002 04:05 Go to next message
Neelima Mohanty
Messages: 2
Registered: October 2002
Junior Member
Iam using Discoverer 3.1, can you pls. help me with this query-
We do not use calender year meaning Jan till December instead we use the financial year April till March, how do I change this in Discoverer so as to reflect in date hierarchy, drilling into detail etc.

Regards
Neelima
Re: Discoverer - change of year periods [message #88574 is a reply to message #88543] Thu, 21 November 2002 05:27 Go to previous message
Geoffrey
Messages: 32
Registered: February 2002
Member
You can use the function add_months

ex : if your fiscal year 2003 starts in april 2002 you can use the function to_char(add_months(date,9),'mm-yyyy')

you will see 01-2003 for any date in april 2002 and if you want to you can build a date hierarchy

regards

Geoffrey
Previous Topic: Re: Parameter input changes report main heading
Next Topic: Writing reports using SQL-Plus
Goto Forum:
  


Current Time: Fri May 27 17:51:27 CDT 2022