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

Making a Date Value to NULL in Expression

Heitor
5 - Atom

I have a date field in my data which i want to replace values, given a certain contition, to NULL.

Trying this IFF funciton, but it gives me "Invalid Type in operator =="

 

DATE_FIELD =

IIF(Left([FieldA],1)=!"B", [Start_Date], Null() )

 

 

 

2 REPLIES 2
JohnJPS
15 - Aurora

Perhaps you want != instead of =!

Smiley Happy

Heitor
5 - Atom

Oh man... Thanks John. Apologies for the rookie mistake.Smiley Happy

Labels