I don't like that idea because that way you need to join tables for simple queries restricted by dates.
To that I always reply that no user should be looking at the information in that manner. Only a developer would have to do this, and they should have no trouble making the join. It's just a simple join.