Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Time Diff Calculation Not Working

chk
5 - Atom

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

5 REPLIES 5
MarqueeCrew
20 - Arcturus
20 - Arcturus

@chk,

 

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

 

You didn't name the new field.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
chk
5 - Atom

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
15 - Aurora

@chk we've all been there

chk
5 - Atom

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
15 - Aurora
I think an idea post is due here
Labels