Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Date format to Quarter

Highlighted
5 - Atom

Worked well. ThankQ

Highlighted
6 - Meteoroid

If you want to make it numerical and sortable, this is what I did: 

 

tostring(DateTimeYear([Year_Month])) + tostring(
(if DateTimeMonth([Year_Month]) in (1,2,3) then 1
elseif DateTimeMonth([Year_Month]) in (4,5,6) then 2
elseif DateTimeMonth([Year_Month]) in (7,8,9) then 3
elseif DateTimeMonth([Year_Month]) in (10,11,12) then 4
else Null() endif))

Highlighted
5 - Atom

hello, to make this formula work, what should be the data format of the output? thanks!

Highlighted
6 - Meteoroid

Thank you! This worked like a champ!

Labels