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
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
Hey @Randy_H - Just following up to let you know that we’ve released an improvement to the Insert If/Else column step to handle date comparisons, number comparisons, and currency comparisons more elegantly! Now, you can compare dates formatted as YYYY-MM-DD with other dates formatted as YYYY-MM-DD.
I know you already have a workaround for this particular solution, but hope you find this useful for future building!