Date Difference

I need an Alteryx formula that will return the number of days between CREATED_DATE and COMPLETION_DATE. Both columns are Date data types. If the CREATED_DATE and COMPLETION_DATE are the same day the formula should return 0.

Below is a sample of the dataset

Developer

Date Time

Data Investigation

Accepted answers

alexnajm

DateTimeDiff([COMPLETION_DATE],[CREATED_DATE],"days")

However, you may have to figure out a way to deal with those null values!

All comments

alexnajm

DateTimeDiff([COMPLETION_DATE],[CREATED_DATE],"days")

However, you may have to figure out a way to deal with those null values!

alexnajm

@nicktekippe I saw the email that this was marked as a solution but I don't see the acceptance on the post. Can you mark the answer as a solution? Thank you in advance!

alexnajm

@nicktekippe I see it now - thank you!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703