Challenge #10: Date Time Calculations

[jstokes1994]

Spoiler

[rahmed]

Spoiler

[ChrissD]

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]

Spoiler

[sonyakasenkramer]

Spoiler

[TarunDeep]

Short and Sweet 1 step solution.

Spoiler

---

[Trumble_dup_334]

Modus, welcome to my Alteryx life!

[Xlblaze]

Spoiler