If Cell = a Certain Date > No result

Andre_Zijlstra · ‎May 14, 2022

Hi everybody,

I would like to create a column that displays an action when a date has reached a certain value.
If the date field is 30/6/2022 the actionfield would read “GO”.

So I tried IF(Date=“30/6/2022”, “GO”, BLANK()), but it wouldn’t work.
IF(Date=Datetime_format(“30/6/2022”,‘D/M/YYYY’),“GO”,BLANK()). No result either.

What am I doing wrong?
The date field has an European Date format (D/M/YYYY).

Thanks in advance!

momentsgoneby80 · ‎May 14, 2022

Hi @Andre_Zijlstra!
In the first version I think it’s
a) an issue with understanding the date format and
b) you don’t have to use “BLANK()” (even though removing that doesn’t fix problem a).
Airtable formulas work as

IF(
condition,
value if true,
value if false
)

If you don’t need a value or output for when a condition is false you can leave that out rather than creating an empty output. If not for problem a, then this would have been the way to write it.

IF(Date='30/6/2022', 'GO')

In version 2 the formula is jumbled and you never tell it where to compare the date to.

This should work for you

IF(DATETIME_FORMAT({Date},'D/M/YYYY')='30/6/2022','GO')

If the date 30/6/2022 is ever subject to change I would suggest using the date field as an action date field and compare to TODAY() rather than a static date in the formula. Something like

IF(IS_BEFORE({Date}, TODAY()), 'Go')

Andre_Zijlstra · ‎May 14, 2022

This one worked fine:
IF(DATETIME_FORMAT({Date},‘D/M/YYYY’)=‘30/6/2022’,‘GO’)

Thank you!