Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello the community,
I am getting this, and wanted to ask if anyone could help me understand what is going on, and help me resolve the issue with my data. thank you
>Getting more than Four (4) quarters...
Quarter is cutting of @4/2/2009
Thank you
Try:
'Q' & Ceil(Month("Order Date") / 3)
Hello, Pierre
tried that it did not work.
Thank you
Hi @nicouek ,
Can you check your date format, looks like what @BrunPierre mentioned is correct?
Result:
Good morning everyone,
Thank you very much for all of your input, updated the scripts this morning and everything seem to work per all of your recommendations. Thank you
This was my process:
'Q' & Ceil(month([Order Date]) / 3) as Quarter --> This setup gave me and extra here "Q"; Q1; Q2; Q3; Q4. ([Order Date] FORMAT = M/D/YYY)
If(Isnum([Order Date]), 'Q') & Ceil(month([Order Date]) / 3) as Quarter --> Q1; Q2; Q3; Q4
If(Isnum([Order Date]), 'Q') --> Removed the extra 'Q' I did not want
Thank you All