This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
The solution to last week's challenge is HERE.
This week we will be offering our third ever challenge on converting strings to dates. Sometimes these may be simple, but every once in awhile, we come across those source systems that drop things in a format that are better understood by machine than by a human. In this week's challenge, convert the string to a date using the following rules:
1) The Input contains dates formatted as year, month, day where the first character details if the year begins with 19 or 20.
2) It is 19 when the first character is 0 and 20 when the character is 1.
3) The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.
Example: 1040202 should become 2004-02-02.
It is actually pretty simple but I was stuck for 15 min with...
Thanks and have a great week all,
I would love to participate to these challenges (to improve my knowledge and learn stuff), however i only have an acces to a 9.5 version of Alteryx so when i try to participate i can't open the input :(
Do you think that it would be possible to have it compatible with my granpa version ?