Help

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

Topic Labels: Formulas
Solved
Jump to Solution
200 1
cancel
Showing results for 
Search instead for 
Did you mean: 
EllieBailey
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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.

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

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.