+3Hello!
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
Best answer by Sho
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")
)
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")
)Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.