Date Difference

[nicktekippe]

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

 

[alexnajm · Accepted solution]

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!