Fyscal year represntation/showing
I need to show the fyscal year field as "07-08","08-09" or "09-10" as a relevant for each record date that the user will input. The date of each record would be; Rec_Date.
So how can I come up with calculation to represent "09-10" if a user inters 01/29/2010 for instance?
Note that fyscal year starts from 10/1(Oct. 1st) and ends; of course; on 09/30 (Sep. 30th) of the following year.
Thank you for the help in advance