Create IF Statement with Date column

[SwizzKZ]

Hello all,

I'm new to this community and very exited in learning this new tool.

Can someone help me with the IF statement ?

I have a date column in mm/dd/yyyy format (string). I need to create a new field , in excel  the formula would be :

=IF(DateColumn="","NA", IF(DateColumn<Today()),"Expired",DateColumn)

[Luke_C]

Hi @SwizzKZ 

You'll need to convert the date field to the alteryx date format (yyyy-mm-dd). You can do this separately or as part of the formula:

IF isempty([DateColumn])

Then 'NA'

Elseif Datetimeparse([DateColumn],'%m/%d/%Y') < Datetimetoday()

Then 'Expired'

Else [DateColumn]

Endif