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

[HarmLommers]

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”))

[JCorrell (Jim - The Monday Man)]

@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"))

[HarmLommers]

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?

[HarmLommers]

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…

[robgibbs]

I had a similar issue and this worked for me…formatting the date when it was being compared to another date…without it, this formula never worked properly.

IF(FORMAT_DATE(TODAY(),"YYYY-MM-DD")<FORMAT_DATE({Work Dates#End},"YYYY-MM-DD"),WORKDAYS(TODAY(),{Work Dates#Start}),WORKDAYS({Work Dates#End},{Work Dates#Start}))