IF Formula Not Working for Dates

Platform discussions Special workflows & use cases
,
1

Hello All,

Hoping that someone can assist. Relatively new to Monday.com, and am trying to do a basic IF statement, however, it is not working appropriately.

IF({Savings Start Date} < DATE(2024,01,01), “Yes”, “No”)

The {Savings Start Date} is a typical Date column. I am getting a No on ALL columns even where the date is before 01/01/2024.

This is only the first part of the syntax I’m trying to build, but is obviously the point of failure to that entire syntax.

Any ideas or suggestions would be much appreciated.

2

Hi Michael,

Enter DATE(2024,1,1) as syntax for your formula and you’ll see that it does not format the date as “YYYY-MM-DD”. That’s the issue when comparing with your Savings Start Date.

So you’ll need to ensure both sides of the comparison are formatted the same way.

These 2 syntaxes should work:

IF({Savings Start Date}<FORMAT_DATE(DATE(2024,01,01),"YYYY-MM-DD"),"Yes","No")

or simpler:

IF({Savings Start Date}<"2024-01-01","Yes","No")

Want to get rid of the formula column? and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at https://mdboosters.com*

1 Like
3

@GCavin,

This worked perfectly, thank you.