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

    Assign Days to Calendar Month

    Aidan O Reilly

      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

       

      etc

       

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

       

      Thanks,

      Aidan