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

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

VipulThakur
7 - Meteor
‎05-15-2023 10:03 AM

Solve this challenge with the below tools:

  • DateTime 
  • Formula 
  • Select
Reply
0 Likes
harrame
8 - Asteroid
8 - Asteroid
‎05-17-2023 01:02 PM
Spoiler
harrame_0-1684353742876.png

 

challenge_359_solved.yxmd
Reply
0 Likes
Robinvm
8 - Asteroid
‎05-19-2023 03:11 AM
Spoiler
Robinvm_0-1684491056300.png

 

challenge_359_solution.yxmd
Reply
0 Likes
syahya
8 - Asteroid
‎05-19-2023 02:38 PM
Spoiler
359 Solved.PNG

 I tried to do this with as few tools as I could. Format the date from a string, split it into columns, and then bring together the year and quarter.

challenge_359_solution.yxmd
Reply
0 Likes
vidyasurendra
8 - Asteroid
‎05-19-2023 04:00 PM

vidyasurendra_0-1684537226726.png

My solution!:)

Reply
0 Likes
Ben-B
7 - Meteor
‎05-23-2023 04:01 PM

Here it is

date to quarterly date.yxmd
Reply
0 Likes
trepryor
8 - Asteroid
‎05-26-2023 08:41 AM

MySolution_ManipulatingDates.png

Reply
0 Likes
boglarkalipka
8 - Asteroid
‎05-26-2023 02:57 PM

solved

challenge_359_solution_solved.yxmd
Reply
0 Likes
caltang
17 - Castor
17 - Castor
‎05-27-2023 09:33 PM

Done!

 

Spoiler
caltang_0-1685248391172.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
challenge_359_caltang.yxmd
Reply
0 Likes
NMangera
11 - Bolide
‎05-30-2023 12:48 PM
Spoiler
NMangera_0-1685476076913.png

 

NOTES

- Formula tool to rule them all!

challenge_359_NM.yxmd
Reply
0 Likes