How can transform a formula into a date?

Platform discussions Special workflows & use cases
1

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?

2 Likes
2

I’m also having the same problem here. I’m trying to add a formatted date column to my calendar but it’s not a valid column type.

3

You can use General Caster to achieve this by casting a formula to a Date column that can be used in a Calendar. There is a free tier as well depending on required usage.

Thanks!
Mark