Solved

Hiding #ERROR! Message from field

+4

Please someone help me to hide #ERROR! - not all my fields have dates insert and in this case ERROR appears

IF(
  AND(
    {date},
    NOW() >= DATEADD({date}, -30, "days")
  ),
  "ending time"
)

thanks a lot 😉

Best answer by DevonK

You’ll have to use a nested if to check if the date exists first:

IF({date},
 IF(
  NOW() >= DATEADD({date}, -30, "days"),
 "ending time"
 )
)

+15

You’ll have to use a nested if to check if the date exists first:

IF({date},
 IF(
  NOW() >= DATEADD({date}, -30, "days"),
 "ending time"
 )
)

+25

Hi,
Note that it is recommended to use TODAY() instead of NOW() when you don't need time.

Sign up