| Discoverer - change of year periods [message #88543] |
Thu, 07 November 2002 04:05  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
