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