Restrictions apply to DATE 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.