community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Date format to Quarter

Worked well. ThankQ

Highlighted

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))

Labels