Alteryx Filter Tool is Misclassifying Records

[davidogundipe]

Hey, 

My filter tool is classifying something as true, when it should be false. I'm not sure why this is happening. I've attached my workflow below. The filter is pretty basic, I'm just checking to see whether the "payment date" came before the "death date". 

[AngelosPachis · Accepted solution]

Hi @davidogundipe , 

I think the issue arises from the fact that your "death date" column is a string data field but the "Payment date" is a date field.

If you convert the death date to a date field type, I reckon that will solve the issue you are facing with your filter tool. You can do that by stocking a DateTime parse tool just before the right input anchor. You can see that the results in the filter tool change

Hope that helps,

Angelos 

[davidogundipe]

I also had to use the date/time tool to convert the dates to a date data type, but this was the issue. Thanks!!

[DavidP · Accepted solution]

Hi @davidogundipe 

Payment and Death Date are in different formats. Try this (see formula tool before join left input)

[davidogundipe]

Thanks!