0 Replies Latest reply: Aug 7, 2017 2:47 PM by Zach Mostowsky RSS

    Populate data in line chart between two dates

    Zach Mostowsky

      Hello All,

       

      I would like to set up a line chart that displays the count of a position, p, required for a contract. The contracts have unique identifiers and a start and end date (when a contract ends the resource frees up and is not included in the count). I found a 90 percent solution to my problem here: Populate data between Start and End dates in line line chart using the import script provided by Jean-Pierre. I would like to translate this answer from days into months however. I can get everything working correctly except the date starts at 12/31/1899 which is a problem. It needs to start at 1/1/2017 or whatever the earliest start date is. Can anyone help out with this problem?

       

      Thanks,

       

      Zach