Add an index to date and loop round that field then, be quicker than using a view.