OraFAQ Forum: Reports & Discoverer » Date to Fiscal Year

Home » Developer & Programmer » Reports & Discoverer » Date to Fiscal Year (disc 10.1.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date to Fiscal Year [message #420030]

Wed, 26 August 2009 11:41

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

Report message to a moderator

Re: Date to Fiscal Year [message #420574 is a reply to message #420030]

Mon, 31 August 2009 10:25

skooman
Messages: 913
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).

Report message to a moderator

Re: Date to Fiscal Year [message #422954 is a reply to message #420574]

Mon, 21 September 2009 07:39

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

Thank You Very much

Report message to a moderator

Previous Topic:	Background image
Next Topic:	How to conceal user id and password while printing report?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 04:36:17 CST 2024