In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎08-12-2022 02:02 AM

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

Labels:
Reply
1 REPLY 1
trsali
Alteryx Alumni (Retired)
‎08-12-2022 07:45 AM

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

Reply
0 Likes
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All