Seperating year by Quarters

[#1]

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.

[#2]

Try

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

See @ZF answer

[#3]

Try this formula:

Quarter(:Date)

[#4]

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.