Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #46: Formatting a Date from an Integer

dillon_bok
8 - Asteroid
Spoiler
Weekly Challenge - 45.PNG
ChrisMelck
8 - Asteroid
 
anaibeth
8 - Asteroid

It's exciting to solve this and the going through the solutions other have posted so I can learn new tools!!!

 

Here's my solution anyways :) 

justindavis
10 - Fireball
Spoiler
challenge_46_solution_justindavis.PNG

I know I can do all of this in one formula expression, just finding working with dates a bit finicky compared to what I'm used to in SQL. But this didn't take too long!

gautamsawant93
7 - Meteor

Here's my solution. I used the formula tool and date-time tool.

RWvanLeeuwen
11 - Bolide
Spoiler
I should remember to use yyyyMMdd instead of yyyymmdd when parsing dates46.png
garthn555
8 - Asteroid
Spoiler
gn_challenge_46.png

This is very simple

Lily_Unsworth
8 - Asteroid
 
joshuaburkhow
ACE Emeritus
ACE Emeritus

This was a good one where I've become a huge fan of @Kenda DateTime macro...

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
Shaun_Rheeder
8 - Asteroid

Lesson learnt. To focus on DateParseFunction...

 

I basically did what the function does except in more steps...