4 Replies Latest reply on Jun 4, 2019 10:04 AM by Deepak Rai

    Getting last of every month in between two dates

    Sriram Chandra

      Hi there,

       

      I'm trying to get the last day of every month in between two dates, Suppose Start Date:01/01/2019 End Date:12/31/2019 then I want

      01/31/2019

      02/28/2019

      03/31/2019

      04/30/2019

      05/31/2019

      06/30/2019

      07/31/2019

      08/31/2019

      09/30/2019

      10/31/2019

      11/30/2019

      12/31/2019

      First date i'm able to get with dateadd and not sure how to loop the iteration. any ideas of how to loop this and get these dates.

       

      Thanks,

      Sriram