Date Time Diff Calculation Not Working

[chk]

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

[MarqueeCrew · Accepted solution]

@chk,

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

You didn't name the new field.

Cheers,

Mark

[chk]

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. 

[LordNeilLord]

@chk we've all been there

[chk]

haha!

I do wish Alteryx made its error messages clear, like "Dude, name your field first if you want me to act" instead of the cryptic message it displayed. 

[LordNeilLord]

I think an idea post is due here