Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #10: Date Time Calculations

Highlighted
Alteryx Partner
Spoiler
jstokes1994_0-1574875706651.png
Highlighted
Alteryx
Alteryx
Spoiler
Challenge 10.PNG
Highlighted
6 - Meteoroid

The problem with this challenge is that I don't even know where to find the formal write up of the functions. I found this page https://help.alteryx.com/2018.4/Reference/Functions.htm but this does not list all the arguments that can be passed to u. 

The examples show how Months, Hours, Days, so I could figure out Seconds, but what if there are other functions there? How can I learn about them? What about micro seconds? I think all the words that can be passed to u should be listed there. Good tip about int16 or int32 potentially not being able to hold enough seconds though.

Highlighted
8 - Asteroid
Spoiler
Capture.PNG
Highlighted
8 - Asteroid
Spoiler
sonyakasenkramer_0-1576602751753.png
8 - Asteroid

Short and Sweet 1 step solution.

 

Spoiler
Solution_Challenge_10.JPG

 

Highlighted
8 - Asteroid
 
Highlighted
7 - Meteor

Modus, welcome to my Alteryx life!

Highlighted
7 - Meteor
 
Highlighted
7 - Meteor
Spoiler
Xlblaze_1-1577092843527.png

Xlblaze_0-1577092914898.png