2 Replies Latest reply: Mar 7, 2016 9:42 AM by Joanna Seldon RSS

    Financial Year

    Joanna Seldon

      Hiya

       

      I am using the code shown to render Financial Year as e.g 2013/2014  2014/2015

       

      Year(addmonths(addyears([Order Date],1),-3)) &'/' & Year([Order Date])

       

      when I do I get

       

      2014/2013

      2014/2014

      2015/2014

      2015/2015

       

      appearing in the pane, I have also tried using the code in the master calendar

       

      Year(addmonths(addyears([Order Date],1),-3)) &'/' & Year([Order Date]) as Financial Year and I get the same

       

      I have tried to

       

      Date(Floor("Order Date"))as "Order Date",

       

      to see if it helps and still no joy

       

      please help