5 Replies Latest reply on Jul 1, 2015 9:02 PM by davidhead

    How to List months between 2 Dates ?

    binu.alexander

      Employees have Monthly Reports .

       

      Some Employees may  submit reports for mulltiple months   i.e  date range  ( start Date )    and( End Date)

       

       

      Can I get the List of Months beween the 2 dates  ?

       

       

         e.g. 1

       

      start date (  1st Jan  2015 )

       

      end date  ( 31st March 2015 )

       

      DESIRED RESULT   =     "January , February , March"      OR    " Jan  -  Mar  "

       

      e.g. 2

      start date (  1st Dec  2015 )

       

      end date  ( 31st May 2016 )

       

      DESIRED RESULT   =     "December , February , March"      OR    " Dec  -  May  "