Challenge #10: Date Time Calculations

[RWvanLeeuwen]

slight deviation in dateTime stamps was found. I appended my own DateTime stamp in case you'd like to switch to production

[ivoller]

This one was easier I thought.

[locunhalima]

My solution.

[dillon_bok]

Spoiler

[alphabex18]

HI there. How can you take your solution and concatenate it in one field as a time stamp of d.hh:mm:ss? But not as a string. Then i can pull out more analytics from it. Thanks ahead of time

[ivoller]

@alphabex18

I'm not sure what you're trying to accomplish. Alteryx only recognizes Date(time) fields in the format of YYYY-MM-DD and provides a bunch of formulas to do arithmetic on them. It also provides functions and the DateTime Tool to convert between strings and DateTime formats. Using the functions you are generally able to achieve whatever level of parsing, arithmetic that is necessary for your analysis.

Perhaps if you gave an example of what results you are aiming for we could help.

Iain

[CaraI]

1 tool solution!  ... well if you don't include the browse tool :)

[JORGE4900]

Hello all,

Here my attempt at solving this challenge. Since I had done a similar solution before, I took the approach of calculating the seconds first, and from there, calculating the days, hours, and minutes while deducting the seconds. After looking at some of the solutions, the solution I like the most was the use of the modulus operator by 

@mceleavey

Spoiler

[JDelgado]

Yep, another quick one - but those formulas start to get a bit hairy as you increase the nesting those date functions!

JohnD