How can transform a formula into a date?

Hi!

I have a series of events and I created a formula to define the deadline of each item based on two collumns:
“EventDate” and “DaysInAdvance”. So I created the following formula:

FORMAT_DATE(SUBTRACT_DAYS({EventDate},{DaysInAdvance}))

But the problem is that I can’t use the result as a date for the timeline view, due date and “My Work” session.

Is there something I can do so I can transform this formula into a date? Did anyone have a similar problem?

1 Like