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

LynnPätzold
8 - Asteroid

my solution:)

Yogesh1795
8 - Asteroid

Once we are comfortable with formulas, challenges become super easy

tmich20
8 - Asteroid
Spoiler
tmich20_0-1682394225316.png

 

Abhishek2412
7 - Meteor

My Submission

Carolyn
12 - Quasar
12 - Quasar

Completed!

 

I did my quarters manually but it looks like newer versions of Designer have a Quarter function?

Asmaa-jirani
5 - Atom
Spoiler
Asmaajirani_0-1682612521287.png

 

Zas3nfkb
8 - Asteroid
Spoiler
Zas3nfkb_0-1682619784793.png

 

VladimirR
8 - Asteroid

Lot of different ways, but below are first three ideas that came to mind. 

Spoiler
However, in all three formulas I'm getting the Q number by dividing the month number by 3 and then rounding it up with CEIL function. Rest is just how I handle date/string formats and parsing.

VladimirR_0-1683579931063.png

 

 

elena_mazareanu
8 - Asteroid

Solved

TungThanhHo
8 - Asteroid

my solution