Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 18, 2024 01:33 PM
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 😉
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 18, 2024 03:41 PM
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"  ) )
Reply
2 Replies 2
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 18, 2024 03:41 PM
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"  ) )
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 19, 2024 01:04 PM
Hi,
Note that it is recommended to use TODAY() instead of NOW() when you don't need time.
Reply
