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

KOBoyle
11 - Bolide

Solution attached. Since a formula was required to convert the first digit, I used the DateTimeParse function. Other responses put me onto the DateTime parse tool, which looks like a much easier way convert strings in a standard format to dates.

-Ken

Elena_Caric
8 - Asteroid

Thanks!

kcgreen
8 - Asteroid

I spent some extra time playing around with this one to make it work with a single formula.

 

Spoiler

 

REGEX_Replace(
(if Left([date], 1) = "1" Then REGEX_Replace([date], "(1)(?:\d{6})", "20")
elseif Left([date], 1) = "0" Then REGEX_Replace([date], "(0)(?:\d{6})", "19")
ELSE "Blank" endif)
+
right([date],6),
"(.{4})(.{2})(.{2})", "$1-$2-$3")

 

challenge46.JPG

 

CHarrison
8 - Asteroid

Here's my solution :) 

Mattpannuzzo
7 - Meteor

My solution

 

 Workflow

Spoiler
challenge46workflowMPannuzzo.png

 

 Formula

Spoiler
challenge46formulaMPannuzzo.png
JordyMicheal
11 - Bolide

Really neat.

Sorry, just going back and solving some

Syfer889
7 - Meteor

Interesting one here. Learning a lot though. Thank you!

luciebrett
8 - Asteroid

Here's my attempt; bit different to the solution as I used left and substring.

mascarenhas_lucas
8 - Asteroid

challenge_46.PNG

 

Spoiler
 
daniel_ferreira
8 - Asteroid

Follow my solution file attached...