26 Replies Latest reply: Apr 29, 2016 2:13 AM by Nitin Gupta RSS

    calendar yr to indian financial yr and Quarter

    naveen kumar

      Hello,

      which function do i need to use to achieve this

              jan

              feb

              mar  as Q4 2015

              apr

              may

              jun as Q1 2016

              July

              aug

              sep as Q2 2016

              oct

              nov

              dec as Q3 2016 

       

      and actual/calendar year is 2015

       

      current my expression is this which is not good

      'Q'&ceil(MONTH(DATE)/3) AS QUATERS,

          year(DATE) as YEAR



      thanks

      naveen