3 Replies Latest reply: Mar 5, 2015 5:03 AM by Jim Chan RSS

    Unable to get the Quarter(Q1,Q2,Q3,Q4) result

    Jim Chan
      Logged_Date
      11/12/2015
      13/05/2015
      15/07/2015
      24/2/2015

       

      Hi guys,

       

      i need to do a year month quarter based on this field, my biggest problem is - i cant get the Quarter result.

      Expression i have used is 'Q' & Ceil(month([Logged Date]/3)) , but i couldnt get a correct quarter result - like Q1,Q2,Q3,Q4.

      the result was Q5,Q7,Q8.

       

      Can you please create a sample based on my field data?

       

      thanks guys.