community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #46: Formatting a Date from an Integer

Asteroid
 
Meteor

Here is my solution

Asteroid

Solution below: 

Spoiler
Snare_0-1573246365053.png 
Used formula to replace the leading 1 with 20 else the leading 0 with 19. Then used DateTime to convert to standard date. Select for the relevant fields.

Formula:
IF Left([date], 1) = '1'
THEN ReplaceFirst([date], '1', '20')
ELSE ReplaceFirst([date], '0', '19')
ENDIF
Alteryx Partner
 
Alteryx
Alteryx
Spoiler
46_screenshot.png
Asteroid
 
Asteroid
 
Meteor

used a regex, took two more steps

Spoiler
nicolomonti_0-1574352102675.png
Asteroid

My Solution: