Help

Removing time from a nested DATEADD

Topic Labels: Formulas
Solved
Jump to Solution
493 2
cancel
Showing results for 
Search instead for 
Did you mean: 
OneFiftyFive155
4 - Data Explorer
4 - Data Explorer

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:

Screenshot 2023-09-27 at 10.36.32 AM.png

My formula:

Screenshot 2023-09-27 at 10.36.26 AM.png

The error message:

Screenshot 2023-09-27 at 10.40.15 AM.png

Any help is greatly appreciated!

George

 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

 

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

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

 

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
4 - Data Explorer
4 - Data Explorer

Thank you!