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

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here is my solution:

sumanthskumar
8 - Asteroid

Number 11

Spoiler
sumanthskumar_0-1589698241458.png

 

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Sharing my solution.

 

Very simple but interesting challenge. 

 

Spoiler
Challenge_41_Emil_Kos.PNG
DMContente
8 - Asteroid

here's my solution

edavilac
8 - Asteroid

My solution attached.

 

Spoiler
Challenge_46_edavilac.PNG
deviseetharaman
11 - Bolide
Spoiler
 
NaiLo
8 - Asteroid

  

izamryan
8 - Asteroid

RegEx! It's your friend!

 

Spoiler
izamryan_0-1590165596397.png


For this one I used a Formula tool with a bunch of formula in series:

[Year]
IF Left([date],1) = "1" THEN 20
ELSE 19
ENDIF

[date2]
Right([date],6)

[date_result]
[Year]+[date2]

I then used a RegEx to slice out the yyyy,mm,dd:
(\d{4})(\d{2})(\d{2})

and then another Formula tool to rehypothecate (!!!) the string
[yyyy]+"-"+[mm]+"-"+[dd]

and finally a Select tool to tidy up.

 

mulvihi11
8 - Asteroid

DateTime tool remains a favorite of mine!

Spoiler
mulvihi11_0-1590695237890.png

 

mhou
8 - Asteroid

🙂