2 Replies Latest reply: Oct 20, 2011 5:24 AM by Aissam Boumejjane RSS

    Not getting the correct quarter number

    Aissam Boumejjane

      Hi Guys,

       

      I have the field quarter that doesn't show the correct quarter numbers:

       

      Based on the script below,

       

      'Q' & Ceil(Month(Date(Date#(OrderDate, 'YYYYMMDD'),'DD-MM-YYYY') /3)) as Quarter,

       

      OrderDate is a string therefore I used the Date# to translate it to a date.

       

      I get these results

       

       

       

       

      What am I doing wrong?

       

      Cheers!

       

      iSam