10 Replies Latest reply: Nov 9, 2017 4:53 AM by raffaele di francia RSS

    Extracting months between 2 dates

    Michael Blackburn

      Hi all,

       

      I'm curious if there's a way I can extract months between two dates... I can get the number of months between 2 dates, but I want to be able to get the actual month names... For example;

       

      Start.Date = 01/01/2017

      End.Date = 31/03/2017

       

      Months between two dates = 3.

       

      Now, I want to output those months in for format of the actual month names,so output should be... Jan, Feb, March...

       

       

      How can I achieve this?

       

      Cheers