(Problems with date calcs) This is all kinds of crazy

This has me stumped. I’m having date calculation issues on a board, so I made a simpler version for testing. Can you explain this behavior?


Yes. Yes, I can.


Just kidding… well, kind-of…

The comparisons are evaluating the dates as strings. “T”>“J”=TRUE, F>J= FALSE, etc.

This will give you the expected results:

FORMAT_DATE({X Days Later}, "Y-MM-DD") > FORMAT_DATE({Janurary 1}, "Y-MM-DD")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in monday.com Formulas? YES!!!

Ah… ok. It’s strange because the code I have in place worked the last few months. I wondered if something changed. I’ll give that a try. Thanks!


I’m very curious as to why it might have worked then stopped. Let me know how it turns out.