Just one suggestion, make the key an int, and populate with the date yyyymmdd (20081216), instead of an identity column.

You might want to create a separate table, for fiscal calendar, that could also be joined to your date table. Again, using the date as an int key. This would contain data that indicates which fiscal week, quarter, year, etc.

Leonard