Skip to main content

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 😉

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"

 )

)

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

Reply


Terms & Conditions