- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 27, 2023 10:42 AM
Hello!
I'm using DATEADD inside an IF. It returns a time with the date, and I would like to remove the time. I tried formatting the field but it says that it can't do that because it's neither text or a number:
The issue:
My formula:
The error message:
Any help is greatly appreciated!
George
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 28, 2023 03:07 AM
Hi @OneFiftyFive155,
Once the empty string("") in the ELSE argument of the IF statement has been removed, it should be possible to format it as a date.
IF(
{Schedule Catch up?} = 1,
DATEADD({Last Catchup}, 90, "days")
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 28, 2023 03:07 AM
Hi @OneFiftyFive155,
Once the empty string("") in the ELSE argument of the IF statement has been removed, it should be possible to format it as a date.
IF(
{Schedule Catch up?} = 1,
DATEADD({Last Catchup}, 90, "days")
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 30, 2023 10:38 AM
Thank you!
