3 Replies Latest reply: Jan 30, 2014 5:38 PM by Fabrice Aunez RSS

    Creating one record per Month

    Michael Gardner

      Hey everyone,

       

      I followed the approach defined by Henric Cronström in his "Generating Missing Data" resource.

      Image 11.png

      In the example above it is filling in the missing records per day.  However, I need to fill in the missing records per month not per day.


      For example, FromDate = 1/1/2013 and ToDate = 1/1/2014 so I need 12 records one for each month (1/1/2013, 2/1/2013, 3/1/2013, etc).

       

      I have used the below solution which seems to work but is not very straightforward.  Is there a more straightforward solution?

       

      Image 12.png