AnsweredAssumed Answered

Fyscal year represntation/showing

Question asked by penhaifai on Jan 29, 2010
Latest reply on Jan 29, 2010 by comment_1


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