Hiding #ERROR! Message from field

[0mauy0]

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 😉

[Devon_Moore · Accepted solution]

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"
 )
)

[Alexey_Gusev]

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