{Date}>Today() comparison doesn't work

Hi All,

I’m novice to formulas in Monday, and I cannot see why this formula won’t work!
In the code the field {Date} is, well, a date field. See screenshot, all dates are shown as in the “Past”.
Can someone point me at the issue?


1 Like

if you force the dates into YMD it will work…

This works:


Hi J,

Thanks, but it doesn’t work for me. Only the dates as below are marked as ‘future’. It’s still messing up day and months I feel?

I think I see the cause. The referred field is apparently not a date field, but text. And it doesn’t handly that well in this format. I’ll adjust the field to a text field, that should fix it.
I’ll ket you know when this was the case…