Data formatter not responding to If/Else statement

Hello,
I converted both columns into YYYY-MM-DD and the if/then is returning the wrong result. Does anyone know what’s going on?
Thank you for your help!

Hi @Randy_H - Thanks for letting us know about this issue. It does look like we’re encountering a bug with our Insert If/Else column when it comes to comparing dates. I’ve reported it and we’ll be taking a closer look.

In the meantime, there is a workaround if you know you’re going to be comparing days, but year and month should always be the same.

You can use the Format Date step and format your date to just display dates
Screen Shot 2020-09-04 at 4.45.36 PM

Comparing by just the dates using the Insert If/Else column does work.

I’ll follow up as soon as we’re able to resolve this issue!

1 Like