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?