The best approach would be to create a date/time dimension.

Using Date Dimensions for Reporting

Storing the dates as-is in a dimension or fact table is a terrible idea. As you have noticed, it is nearly impossible to do effective analysis on such kind of data. You'll need to split it in a seperate date and time dimension.