Why is my date comparison not working?

[wonka1234]

Hi,

I am having trouble comparing dates in alteryx.

Why are my comparison logic not working properly?

These are in string format. But when I convert to "DATE" format they show as Null.

[Amilley]

The issue here is you are actually doing string comparison Vs data comparison. If you then simply use a select tool in order to do type conversion, the challenge there is that the fields are not in the ISO standard date format - the solution? Use the DateTime tool in the parse category to convert to a true date field and then run your comparison

[Amilley]

First one in the list

[Luke_C · Accepted solution]

Hi @wonka1234 \

@Amilley is spot on. Alteryx only supports yyyy-mm-dd format for datetime operations. Here's a formula that would work using the DateTimeParse function:

Read more about working with dates here: DateTime Functions | Alteryx Help

if datetimeparse([Delivery],'%d-%b-%y') > datetimeparse([Planned],'%d-%b-%y')
then 'Fail'
else 'Pass'
endif

[wonka1234]

@Amilley  thanks, is there a way to do this in a mass way? I have many date fields lol

[Luke_C · Accepted solution]

Use a multi-field formula tool with 

datetimeparse([_CurrentField_],'%d-%b-%y')