top of page
Ed Orlando
Data Scientist | White Lodging
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









bottom of page