1 Reply Latest reply on Aug 2, 2017 2:57 PM by Deepak Rai

    How to get names of months between two dates?

    Nissim Panchpor

      Hi,

       

      I have Start Dates and End Dates like this:

       

       

      Start_DateEnd_Date
      9/30/2016 12:00:00 AM1/4/2017 12:00:00 AM
      1/4/2017 12:00:00 AM4/26/2017 12:00:00 AM
      4/26/2017 12:00:00 AM7/17/2017 12:00:00 AM
      7/17/2017 12:00:00 AM9/25/2017 12:00:00 AM
      9/25/2017 12:00:00 AM12/20/2017 12:00:00 AM
      10/16/2016 12:00:00 AM12/17/2016 12:00:00 AM
      12/17/2016 12:00:00 AM2/18/2017 12:00:00 AM

       

      I want to get the names of months between the dates. For example for the first row, I need September 2016 (or 9-2016), October 2016 (or 10-2016), November 2016, December 2016 and January 2017. The reason I need these is because I want to use the months to filter a line graph to show the part of it with only those months and year. Thanks in advance!