This content has been marked as final. Show 2 replies
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?