Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

jackieheer
8 - Asteroid
 
MarMu
8 - Asteroid

 

Pretty straight forward solution to this weeks challenge.

 

Spoiler
challenge_46_start_file_MarMu.png
JoBen
11 - Bolide

Cheers! I work with dates in this format everyday. Very practical application. 

ksheerasagarm
8 - Asteroid

Here is the Solution for Challenge 46

Aidan_K
11 - Bolide

Here is my solution, I would say there is a lot of ways to complete this one....

thanks,

A.

pasccout
8 - Asteroid

Here is my solution

NNO
7 - Meteor
 
theboss22
7 - Meteor
 
Ruud
10 - Fireball

I have an unhealthy and unfounded hatred towards the DateTime tool.

zm1
6 - Meteoroid
Spoiler
 I noticed a pattern in the data that strings that started with "1" were for the year 2000 onward. RegEx made it so that I had the first digit parsed out and the remaining six digits in another field. Then, if the result from my first parsed group was "1," I added "20" to the front of the second parsed group (and "19" otherwise). Then used the DateTime tool to convert the string to a DateTime field and Select tool to truncate it to a Date field. Voila.