topic Re: Calendar Quarter in App Development

Calendar Quarter

nicouek — Wed, 05 Jul 2023 01:08:29 GMT

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

BrunPierre — Wed, 05 Jul 2023 02:21:19 GMT

Try:

'Q' & Ceil(Month("Order Date") / 3)

nicouek — Sat, 08 Jul 2023 18:28:39 GMT

Hello, Pierre

tried that it did not work.

Thank you

simsa — Sat, 08 Jul 2023 19:48:12 GMT

Can you check your date format, looks like what @BrunPierre mentioned is correct?

Result:

nicouek — Sun, 09 Jul 2023 12:11:45 GMT

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