Discussions

 View Only
  • 1.  Timeline Table activity with no end date

    Posted 09-11-2019 14:40
    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
    ------------------------------


  • 2.  RE: Timeline Table activity with no end date

    Posted 09-11-2019 17:43
    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
    ------------------------------



  • 3.  RE: Timeline Table activity with no end date

    Posted 09-11-2019 17:44
    Everett,  thanks for the reply. I just got done implementing that based on further research and it works as expected. Thanks for your time!

    ------------------------------
    Louis Wambsganss
    ------------------------------