Home » Developer & Programmer » Reports & Discoverer » Date to Fiscal Year (disc 10.1.2)
Date to Fiscal Year [message #420030] Wed, 26 August 2009 11:41 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi All,
Our fiscal year starts from July 1st, for example "July 1st 2009 to Jun 30th 2010 is considered as FISCAL YEAR 2010.
My problem is i have a date field "ISSUED_DATE" and i have to set it as a page item , so that they can filter view the report by each fiscal year.Any help or advice is greatly appreciated.

Thanks
Re: Date to Fiscal Year [message #420574 is a reply to message #420030] Mon, 31 August 2009 10:25 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Create a calculated item something like
'FY'||to_char(add_months (issue_date,-6),'yyyy')

for example for 31 August 2009 this will give you: FY2010.

Then use that one the way you need it (for instance on a page item).
Re: Date to Fiscal Year [message #422954 is a reply to message #420574] Mon, 21 September 2009 07:39 Go to previous message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Thank You Very much
Previous Topic: Background image
Next Topic: How to conceal user id and password while printing report?
Goto Forum:
  


Current Time: Fri Dec 02 16:31:17 CST 2016

Total time taken to generate the page: 0.34252 seconds