3 Replies Latest reply on Oct 18, 2016 1:21 PM by derek.leung.0

    Fiscal Year Minus One

    derek.leung.0

      This should be an easy one - I just haven't been able to figure it out or see anyone on the discussions have the same problem as me.

       

      I'm trying to use the fiscal year function, but it's displaying forward one year rather than one year backwards (for my purpose.) If I can somehow get fiscal year to work exactly as it is, minus a year, it would be perfect. I've tried some date functions like subtracting a year or 365 days to no avail, due to the misalignment of some days that differs year by year. This produces inaccurate results and I've eliminated this as a possibility.


      Any ideas folks?