Skip to main content
Solved

Computed dates in Timeline view

  • October 28, 2021
  • 3 replies
  • 49 views
J
Forum|alt.badge.img+2

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!

Best answer by kuovonne

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.

3 replies

Kamille_Parks11
Forum|alt.badge.img+27

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)
    J
    Forum|alt.badge.img+2
    • Jord
    • Author
    • New Participant
    • October 28, 2021

    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

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • Answer
    • October 28, 2021

    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.

      Terms & ConditionsAccessibility statement