Challenge #46: Formatting a Date from an Integer

[KOBoyle]

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]

Thanks!

[kcgreen]

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")

[CHarrison]

Here's my solution :) 

[Mattpannuzzo]

My solution

 Workflow

Spoiler

 Formula

Spoiler

[JordyMicheal]

Really neat.

Sorry, just going back and solving some

[Syfer889]

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

[luciebrett]

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

[mascarenhas_lucas]

Spoiler

[daniel_ferreira]

Follow my solution file attached...