Challenge #46: Formatting a Date from an Integer

[akuma38]

 My solution

[mattnason1]

Quick easy one.

[mattbov92]

My Solution

[christopher_ontkean]

Solution

[Leonard_Ellis]

solution:

[Rajan_Sutradhar]

Hi Everyone,

My first success.😁

To solve this challenge I used RegEx & Formula tool.

Broke the string using expression .(\d{2})(\d{2})(.+) in regex, then used

formula to concatenate

tostring(if left([date],1) = "0" then 19
else 20
endif) + [RegExOut1]+ "-" + [RegExOut2] + "-"+[RegExOut3]

everything in one column & changed the datatype to date.

[jamescaosydney]

Challenge 46 solution

[tinanguyen16]

Solution

[AngelaFowler]

Here's my attempt 😃

[cfulton1]

Solution attached