Asking if a date has passed, returning 'yes' or 'no'.

[EllieBailey]

Hi,

I would like a new field that tells me if a date has passed on an old field, called due date.

So I would like the new field to say 'Yes' if the date has passed, 'No' if the date has not yet passed, and blank if no date provided.

Going around in circles with this one so any help would be appreciated. 

Thank you!

[kuovonne · Accepted solution]

How about 

IF(
  IS_BEFORE({due date}, TODAY()),
  "Yes",
  "No"
)

 The date related functions are documented in the Formula Field Reference.

Note that depending on your timezone and when you check the field, there might be a few hours when the formula does not have the expected value.