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.
Jim