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
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!