Skip to main content
Question

Timeline Table activity with no end date

  • September 11, 2019
  • 0 replies
  • 39 views
All,

  I could not find a fix for this issue. I've built a simple timeline report. Each entry has a field for start date and stop date. Entries with start and stop dates show up on the timeline as expected; no issues. However, entries without an end date (activities that are currently still in work) do not show a line on the timeline. 

 How can I make an in-work activity (end date null) populate a line in the timeline from start date to today? With "today" being a dynamic date field that changes every day. 

Thanks in advance!

------------------------------
Louis Wambsganss
------------------------------
    This topic has been closed for replies.

    EverettPatterso
    Forum|alt.badge.img+10
    Make a new formula date field and use that as your end date on the timeline

    Formula date
    If(
IsNull([stop date]), Today(),
[stop date])​


    ------------------------------
    Everett Patterson
    ------------------------------
      Terms & ConditionsAccessibility statement