ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #359: Manipulating Dates

Timi8
8 - Asteroid
Spoiler
Timi8_0-1677250912382.png

 

EdoardoAversaTIL
8 - Asteroid
Spoiler
EdoardoAversaTIL_0-1677251052055.png

 

Coakles
7 - Meteor

Coakles_0-1677255116596.png

 

ashishsehgal
5 - Atom

Here is solution for the weekly challenge:
We used parser then formula to extract year combined with text 'Q' and text of  celling value of Month/3 . 

ashishsehgal_0-1677261236078.png

 

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1677266767215.png

 

randall_king
Alteryx Alumni (Retired)

I like seeing people trying this in Designer Cloud Classic!

Qiu
21 - Polaris
21 - Polaris

done

Spoiler
challenge_359.PNG
h_Ishikawa_ts
7 - Meteor

My solution

h_Ishikawa_ts_0-1677327947034.png

 

naushadalir
7 - Meteor

My solution. I was tempted to use date parse and then realised there might be another way. 

 

Spoiler
naushadalir_0-1677351570963.png

 

jpowellsd
Alteryx
Alteryx

Nice quick on

jpowellsd_0-1677378899696.png

 

Spoiler