Today function not working as expected

Platform discussions Special workflows & use cases
1

Hi

I have two date columns, Due Date and Date Tody; see formula below that works. the only problem is that i have to manually change the date under Date Today column for this formula to make sense.

IF({Due Date}=“”,“?”,IF({Due Date}<{Date Today},“Yes”,“No”)). In the screenshot, the values are captured under Overdue

I tried replacing my custom Date Today column with the Today() function

IF({Due Date}=“”,“?”,IF({Due Date}<TODAY(),“Yes”,“No”)). In the screenshot, the values are captured under Overdue 2.0

But, it doesn’t seem to yield the desired results; now it only yields “?” or “No”. What should I do to display “Yes”, where applicable?

image
image731×414 15.9 KB

2

Hi Hilal,

Try

IF({Due Date}="","?",IF({DueDate}>FORMAT_DATE(TODAY(),"YYYY-MM-DD"),"Yes","No"))

If you want to take your monday formulas to the next level, check out the Advanced Formula Booster at https://mdboosters.com.

3

Yes, your logic works. I changed the sign from > to < to suit my needs. Thanks, Gilles.