4 Replies Latest reply: May 20, 2016 8:38 AM by kushal chawda RSS

    Assign Days to Calendar Month

      Hi there


      If I have a row with a start date of 25/4/2016 and an end date of the 3/5/2016


      How would I go about splitting this into calendar days


      The output I would like to see is as follows;


      Row_ID      April-16     May-16     Total

      123               5               3                8




      I would have thousands of rows of data so would need some kind of loop I would imagine