topic Re: Seperating year by Quarters in Discussions

Seperating year by Quarters

jearls11 — Fri, 09 Jun 2023 22:09:04 GMT

I am trying to seperate the year by quarters using dates. I was looking at documentation and it gave the extract function.

EXTRACT( datepart, datetime, )

I am not sure how quiet to use it, my idea is if data is between Jan 1st and March 28th its Q1 etc

I could use if (Jan1st <:Date< Jan1st + In Weeks( 13 ), "Q1",

Jan1st + In Weeks( 13 )+ In Days(1) <:Date< (Jan1st + In Weeks( 13 )+In Days(1)) + In Weeks(13), "Q2", etc...

is this too complicated.

txnelson — Sat, 20 Mar 2021 15:43:05 GMT

Try

floor( month(:date) / 3 ) +1;

See @ZF answer

ZF — Sat, 20 Mar 2021 15:31:31 GMT

Try this formula:

Quarter(:Date)

Georg — Sat, 20 Mar 2021 18:06:48 GMT

Using JMP15, when looking for formulas it is always a good idea to try "New Formula Column" from the columns menu.

This often helps me to do the first step.