I have been working on the same problem ( in QT-C++ though). I decided that the best method would be to make an iterator that would generate each date between start date and end date . This is very close to what you are proposing, except that I would dynamically generate the dates because I do not see the feasbility of generating a table that contains all the dates from some_past_date to infinity (which is how long I hope people use my application:)

I am glad you ask the question though, because I am interested in hearing peoples opinions.