Removing time from a nested DATEADD

[OneFiftyFive155]

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

 

[Sho · Accepted solution]

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

[OneFiftyFive155]

Thank you!