Warning Message When Reading Time 24 Hours - Input Data Tool

Question

Hello,

I workflow that has a field computing the time elapsed between 2 dates using MySQL's TimeDiff. Problem is, Alteryx flags it as an invalid time format if it is greater than 24 hours. Alteryx flags as warning as early as the Input Data Tool, so I don't have the chance to correct it.

One thing I'm considering is just to get the 2 dates and let the formula tool do the computation. Problem is, what format would be acceptable (to Alteryx) to output it as? Ideally, one that can be sorted and not as string.

Thank you very much in advance, Alteryx community. This has been a big help in my Alteryx journey. 🙂

RonGatmaitan · Answer

Thanks for this, @atcodedog05. Will have a go at it as well. 🙂

atcodedog05 · Answer

Hi @RonGatmaitan

Here is how you can do it.

Workflow:

Note that even though this is in HH:MM:SS format this is not the actual time since hour > 24

Hope this helps : )

time diff.yxmd

RonGatmaitan · Answer

Thanks for this. I'll ask if this is acceptable to the users. So no way I can format in HH:MM:SS if it's a time difference?