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 #58: An Odd String to Date Conversion

alishadhillon__
8 - Asteroid

Screenshot (117).png Here's my solution 🙂

rajatsadan
8 - Asteroid

Solved!!

Inactive User
Not applicable

Here is  my first attempt on weekly challenge. Here is my solution.

 

 

OwenBData
8 - Asteroid

My solution:

Spoiler

 

 

Challenge 58.PNG

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

One tool solution.

 

Spoiler
AkimasaKajitani_0-1603018356087.png

Function:
IF Left([date],1)="1" THEN
DateTimeParse("20"+Right([date],6),"%y%m%d")
ELSE
DateTimeParse("19"+Right([date],6),"%y%m%d")
ENDIF

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-23 à 18.33.55.png
MikeLR
8 - Asteroid
Spoiler
MikeLR_0-1604507215003.png

 

MattBenj
9 - Comet

Completed.

Sashikumar
8 - Asteroid

Good

Spoiler
ch58.PNG
grazitti_sapna
17 - Castor

Hi,

 

Here is my approach to the Challenge.

 

Thanks!

Sapna Gupta