Help

Computed dates in Timeline view

Topic Labels: Views
Solved
Jump to Solution
1016 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Jord
4 - Data Explorer
4 - Data Explorer

I have a date field (Publication Date) and a negative number field (Days) for the amount of days before that content is usually submitted for that publicaiton.

I’m using the following formula to get the submission date, avoiding weekends, which works.

DATETIME_FORMAT(WORKDAY({Publication Date},Days),'D/M/YYYY')

My question is, is there a way to use the computed date and Publication Date in a Timeline view? The computed date would be the start date and the date field would be the end date.

Thank you!

p.s. I was forced to choose a tag and Timeline wasn’t an option so I went with Gantt!

1 Solution

Accepted Solutions

Just turn off the time in the formula’s format settings.

See Solution in Thread

3 Replies 3

DATETIME_FORMAT() is forcing your formula to output a string instead of a date. Either remove it from the formula or use a second field that outputs a straight date and use that field for the timeline view:

WORKDAY({Publication Date},Days)

Hi Kamille, thanks for your reply

I added the DATETIME_FORMAT() as there was a time in the WORKDAY() output whereas we don’t use time in the Publication Date field.

Is a time field unavoidable here?

Thanks

Just turn off the time in the formula’s format settings.