Create a new field based on a date

Question

I am trying to create a new field using conditional logic.  One of the conditions is that if the date in a field is less than the date specified the new field should have a particular value.  My less than logic is not working, I am getting an invalid type in operator error.  I am new to alteryx and I think I am making a simple syntax error, but I can't find a solution anywhere else.  Thanks for the help

Phil

DataBlender · Accepted Answer

Hi @PhilAnthony, try putting the dates in inverted commas.

IF [Return Term 1] = '0645' THEN 'ENR'
ELSEIF [Confer Dt] < '2009-04-01' THEN 'GRD'
ELSE 'LFT'
ENDIF