Find quarter out of date in Alteryx

[LeoMessi]

Hi,

I am trying to figure out Quarter from input as a date in my data. 

Attaching the sample dataset. Any suggestions will be a great help. 

Regards,

[RSreeSurya]

Hi,

Attaching the workflow. 

[FrederikE]

Hey @LeoMessi,

You could do it with the new (23.1 required) BETWEEN-Function. 

IF Between([MonthNr], 1, 3)
THEN 'Q1'
ELSEIF Between([MonthNr], 4, 6)
THEN 'Q2'
ELSEIF Between([MonthNr], 7, 9)
THEN 'Q3'
ELSE 'Q4'
ENDIF

[danilang]

Hi @LeoMessi 

You can find the quarter using the following equation in a formula tool, independent of the Alteryx version you have installed

Ceil(DatetimeMonth([Date])/3)

the Ceil() function returns the smallest Integer greater than or equal to its input, which in this case is Month/3.

Dan