• Yes you can create partition on date column.

    refer to :-

    http://msdn.microsoft.com/en-us/library/ms345146(v=sql.90).aspx