Alteryx formula not recognizing 2018 is not before 2017

Hello,

I have an if then statement that is not recognizing one date (2018-01-16) is after (2017-12-29). The statement looks like this: If 2018-01-16<2017-12-29 then true otherwise false. It keeps saying false. I have made sure the field names are set as dates and it still won't recognize it. So then I hard coded with the dates in the example and it still won't work. I took this code from a Business Objects report so I know the logic is correct. I just don't understand why it doesn't recognize the date?

Any ideas?

Expression

Accepted answers

MarqueeCrew

I'll send you a webex if you'd like, but please check this:

[Early Date] < [Later Date] = True Result

All comments

patrick_digan

@kpombo When you say If "2018-01-16" < "2017-12-29", I would expect it to return false because 2018 is not less than 2017. If you wanted to check that the first date of your argument is after the second argument, you would just want to flip your inequality around to if "2018-01-16" > "2017-12-29" which will return true since 2018 is after 2017. Let me know if it's still not working as expected!

MarqueeCrew

@kpombo,

Try thinking like this: translate "<" as: This date comes before That date (alphabetically).

"2018-01-16" > "2017-12-29"

Cheers,

Mark

kpombo

@marqueecrew I formatted both of the fields (not the hard coded dates) as dates but it still won't work.

kpombo

See I formatted both fields as dates when I didn't hard code and use the "<" and it still wouldn't work but works just fine and returns correct results in Business Objects. I will try it flipped with the two fields set as dates!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703