The Inspire Cyber Monday promo has been extended to Dec. 1! This offer is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Retrieving YYYY QQ from a date. For example 2022 Q3 for todays date

anayet1988
8 - Asteroid

DateTimeFormat([Date],'%Y Q') + ToString(Ceil(ToNumber(DateTimeFormat([Date],'%m'))/3))

1 REPLY 1
trsali
Alteryx
Alteryx

@anayet1988 is this a new column? If so you will have to change the data type to string to see 2022 Q3.

Labels