1 Reply Latest reply on Mar 16, 2016 3:46 AM by Steve Martin

    Fiscal year starting on first Sunday of December

    Sidhu Suresh

      Hi,

       

      I have a date field and I am trying to find out the fiscal year for the same. I am currently using the following formula so as to get the fiscal year:

      IF MONTH([Date])=12 THEN  YEAR([Date])+1

      ELSE YEAR([Date]) END

      But my fiscal year calendar starts every first Sunday of every December. Please help me modify the formula so as the get the fiscal year.

      Thanks in advance.