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.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

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 #46: Formatting a Date from an Integer

NatSnook
8 - Asteroid

probably way more complicated than it required but here is is

bkclaw113
8 - Asteroid
 
erick_irigoyen
Alteryx Alumni (Retired)

Solution attached

cgoodman3
12 - Quasar
12 - Quasar

Here's my solution and like @NicoleJohnson spotted this is a duplicate.

 

Spoiler
Challenge 46.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
EFran
7 - Meteor
Spoiler
46.png
dpcurtis
7 - Meteor

Same basic process but one extra step. Getting better

FredySantana
7 - Meteor

Solved

Spoiler
46_solved.PNG
rachelgibbons
8 - Asteroid

Solved. 

gguedes1
8 - Asteroid

Originally started with Regex Replace, but my experience with Regex and my understanding is minimal. Then thought of replacingfirst Character, however, the first two characters would be replaced instead of the first character with '19' or '20'. I then decided to use a function someone used to solve the challenge as a reference point, however, the datatype stilled produced an issue with truncation ( solution involved in increasing the size of the datatype).

RobertoEstrada
8 - Asteroid

My solution posted here.