2 Replies Latest reply on Dec 22, 2017 5:57 AM by Daniel Strom

    Help with table of dates

    Daniel Strom

      Hi all,

       

      i'v got an datebas that looks something like this:

       

       

      Now i would like to aggregat the number of costumers per month of that year (there are many more years in the real data-set)

       

       

      So, my problem is that i dont have any dates other then the start & enddates. I have tried to join an excel with one column of just '2010-01'. '2010-02' and so on, and then datediff=0 with my start & enddates to get an amount per month but i did'nt work.

      Any ideas how to 'build' a date-table to compare my dates without building it in directly into the database? Or any other solution?

       

      Thanks in advance

       

      Daniel