​​​​Ed Orlando​

Alteryx Weekly Challenge #46

Formatting a Date from an Integer

​

https://community.alteryx.com/t5/forums/recentpostspage/user-id/19037

​

​

Data Prep Date Formatting:

​

Use case: The Input contains dates formatted as year, month and day. In this case the first character determines if the year should begin with 19 or 20.   If the first character is 0 then the year starts with 19, and when the first character is 1 the year starts with 20.  

The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.

Objective: Please convert these strings into date formatted field.

​

Data Set #1                                                                                                      

Final Data Set Solution

Workflow with Detail

​

​

​