In the report that I am creating,
the user inputs, 200710 (which is a number filed in database) as a parameter. 2007 as year and 10 as month. Now I need to convert that to FY 08. Fiscal year 08 starts in July of 2007 and ends in June of 2008.
I have converted the parameter to a date field in crystal reports.So how do I convert that date to a fiscal year for my report heading.
Please advise.
Thanks in advance.