Date as a part of primary key

[slimdave]

A case where it probably wouldn't change would be such things as date-based lookup tables, which you might want to be index-organized.