{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?

If({Date}>Today(),“Future”,If({Date}=Today(),“Today”,“Past”))

1 Like

@HarmLommers,
if you force the dates into YMD it will work…

This works:

If(FORMAT_DATE({Date},"YYYYMMDD")>FORMAT_DATE(TODAY(),"YYYYMMDD"),"Future",If(FORMAT_DATE({Date},"YYYYMMDD")=FORMAT_DATE(TODAY(),"YYYYMMDD"),"Today","Past"))
2 Likes

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…