community Alteryx IO Mission Control
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
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
10 - Fireball
‎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