Any particular reason you didn't use a natural int primary key of the form yyyymmdd?

We've found that to be pretty typical in Kimball-style DW designs, and it still leaves options for special int values.

You could even combine it with identity by applying the identity later or allowing identity insert.