core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
My solution.
My solution for this weeks challenge!
Hi! Here my solution :)
A silly way but...
REGEX_Replace(ToString(ToNumber([date])+19000000),"(\d{4})(\d{2})(\d{2})","$1-$2-$3")
Completing old challenges. Could be done in one tool, but faster to use DateTime tool
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.
My solution
My Solution attached.
Cheers
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 :)