We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #58: An Odd String to Date Conversion

JoeM
Alteryx Alumni (Retired)

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.

 

lbansal
5 - Atom

Here's my solution. Quite an easy one.

Thanks.

Max06270
7 - Meteor

Hey guys,

 

It is actually pretty simple but I was stuck for 15 min with...

 

Spoiler
the fact that my result was truncated to 7 characters all the time... then I realize that I had to change the field type or size...

 Capture.PNG

Thanks and have a great week all,

Maxime

JeffF
Alteryx
Alteryx

Single formula method.

paul_houghton
11 - Bolide

Nice little thinking problem. posted mine on the gallery

 

My example

PaulRB
8 - Asteroid

Too easy. 

Hartwick96
6 - Meteoroid

Here is my attempt...

rajiv_tarafdar
6 - Meteoroid

As this could be used for multiple conversions, I made a macro out of this.

 

Cheers

Rajiv

DinoF
6 - Meteoroid

Hi,

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 ? 

Cheers

JohnG
5 - Atom

My solution. Looking at other examples and I ended up with a very similar approach. Why break a working system 🙂