The following restrictions currently apply to DATE, TIME, and DTTM indexes:
Cannot use the UNIQUE keyword.
Can only be created on a single column.
Do not support date parts Calyearofweek, Calweekofyear, Caldayofweek, Dayofyear, Millisecond.