5 Replies Latest reply on Sep 22, 2015 7:15 AM by erolst

    calculate first month of quarter

    rivet

      how can I find the first month of a quarter.

       

      I found my quarter with:  ( current date: sep 21 )

      Ceiling ( Month( Get ( CurrentDate ) ) /3 )
      

      returns 3

       

      I could hard code it:

      Choose ( Ceiling ( Month( Get ( CurrentDate ) ) /3 )  ; 0;1;4;7;10 )
      

       

      But I am looking for something to handle various fiscal starts.