1 Reply Latest reply on Jan 29, 2010 1:07 PM by comment_1

    Fyscal year represntation/showing

    penhaifai

      Title

      Fyscal year represntation/showing

      Post

      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