Challenge #46: Formatting a Date from an Integer

[mbonora]

My solution.

[kexelby]

My solution for this weeks challenge! 

[RichoBsJ]

Hi! Here my solution :)

[jdunkerley79]

A silly way but...

Spoiler

REGEX_Replace(ToString(ToNumber([date])+19000000),"(\d{4})(\d{2})(\d{2})","$1-$2-$3")

[T_Willins]

Completing old challenges.  Could be done in one tool, but faster to use DateTime tool

[RandeepB]

Used the ReplaceFirst function- although after looking at other solutions I think I will give this ago with using the Switch function as I haven't used this before. 

[archietao]

My solution

[Strohy]

My Solution attached.

Cheers

[TharunReddy]

STEP 1: Use Formula tool to get the exact year

STEP 2: Parse the string to Date format using DateTime Parse tool

STEP 3: Select the desired Columns for output

Happy Practice :)

[KeithTroutt]

My solution