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 #46: Formatting a Date from an Integer

dvaldez
7 - Meteor

I used Regex to parse out the year code and the rest of the date information. Then a formula tool to DateTimeParse the strings.

 

Thanks.

 

Spoiler
alteryx_challlenge_46.png
Kdo
6 - Meteoroid

This is a good challenge to start with :) - I have attempted with the following workflow. Thank you!

hbenigno
7 - Meteor

           

barrymoe
8 - Asteroid

Interesting and a lot of ways to do this one

MichaelHall
7 - Meteor

My solution.

mattnason1
9 - Comet

Quick and easy.

Will_Condon
8 - Asteroid

Ta da!

Spoiler
Challenge 46 Soluton WC Spoiler.jpg

AHill06
8 - Asteroid

seemed to simple, perhaps i'm missing something....

jwbtx20
8 - Asteroid

Short & sweet! 

 

I could see this being a bigger challenge if the data had come from multiple sources, including manual keypunches (e.g. what to do with something like this 1040232), but to the original point by GeneR in the challenge post, it does show how quickly some system conversion issues can be solved!

 

Another one down!

 

Spoiler
challenge_46_spoiler.png
Inés
7 - Meteor

my solution