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

daiphuongngo
9 - Comet

Completed

Jodelgado518
6 - Meteoroid

My solution

daiphuongngo
9 - Comet
Spoiler
Challenge #46 Formatting a Date from an Integer.jpg

TungThanhHo
8 - Asteroid

my solution

willstom24
7 - Meteor

Here is my solution to challenge #46

jamesbarker
7 - Meteor

My solution

OzlemSigbeku
8 - Asteroid
Spoiler
OzlemSigbeku_0-1666798663831.png

 

DenisZ
11 - Bolide

Here is my solution

Spoiler
DenisZ_0-1666849326899.png

 

ShankerV
17 - Castor

Another good one!!!

 

Found interesting!!!!

 

Here is my solution!!

ShankerV
17 - Castor

After my solution, when I checked the solution attached by the author

I noticed they have used just one tool to derive the solution

 

By minimizing the tools, we can built a workflow which will not look complex where one tool is used to make one function.

 

Solution file learning

if Left([date],1  == "0" then DatetimeParse("19"+Right(date],6, "%Y%m%d)

else DatetimeParse("20"+Right(date],6, "%Y%m%d)

endif