Date Time Diff Calculation Not Working

I have two date time columns- CompleteDate and CreateDate. i just need the difference in days.

DateTimeDiff([CompleteDate],[CreateDate],"days") shows an error saying The Field ""is not contained in the record" (Expression #1)

No idea what I should do here. Please help! Thank you

Date Time

Accepted answers

Don't hurt yourself when I explain the error message.

You didn't name the new field.

Cheers,

Mark

All comments

Don't hurt yourself when I explain the error message.

You didn't name the new field.

Cheers,

Mark

Thank you !!! I am new to Alteryx and exactly 2 hours later I'm even amazed that I can do much, so I won't hurt myself for this.

I will hurt myself for working with excel all these years and not moving to Alteryx sooner.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703