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 #10: Date Time Calculations

jstokes1994
7 - Meteor
Spoiler
jstokes1994_0-1574875706651.png
rahmed
Alteryx Alumni (Retired)
Spoiler
Challenge 10.PNG
ChrissD
7 - Meteor

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.

jackdaniels
8 - Asteroid
Spoiler
Capture.PNG
sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1576602751753.png
TarunDeep
8 - Asteroid

Short and Sweet 1 step solution.

 

Spoiler
Solution_Challenge_10.JPG

 

rmassambane
10 - Fireball
 
Trumble_dup_334
7 - Meteor

Modus, welcome to my Alteryx life!

MitchKibble
7 - Meteor
 
Xlblaze
7 - Meteor
Spoiler
Xlblaze_1-1577092843527.png

Xlblaze_0-1577092914898.png