Calculating # hours between dates

Hi everyone!

I have a data set with two date columns, one being inquiry opened date and the other being inquiry closed date. Both are DateTime data types. What I would like to do is calculate the number of hours elapsed for each row, between the two columns. Does anyone know of a way to do this? I was trying to write a formula but you can't really subtract dates and times, supposedly, so now I am stuck.

Any help you can provide is greatly appreciated. Thanks in advance!

Date Time

Help

Data Investigation

Accepted answers

BenMoss

Within the formula tool there is a syntax that allows you to do this...

DateTimeDiff([dt1],[dt2],units)

In your instance units would be 'hours'

Then your two date time fields would be dt1 and dt2.

Ben

All comments

Kenda

Hey @paigeblackstone!

You can actually find the difference between dates and times using the DateTimeDiff(dt1,dt2,u) formula. For more information on this, go to this Alteryx article: https://help.alteryx.com/current/Reference/DateTimeFunctions.htm

Hope this helps! Let us know if you still need more guidance.

BenMoss

Within the formula tool there is a syntax that allows you to do this...

DateTimeDiff([dt1],[dt2],units)

In your instance units would be 'hours'

Then your two date time fields would be dt1 and dt2.

Ben

paigeblackstone

hi @barnesK and @BenMoss,

does it matter which date is entered first? Should the later date be listed first or will Alteryx still understand that you need the absolute difference between the two?

This seems to be exactly the solution I was looking for!

Thank you

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703