The attribute's data type is not compatible with the rule type.

Question

I can't do a rule 'must be unique' with a Datetime.

On MSDN web site, it suppose to be working...

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

The selected attribute must be unique independently or in combination with defined attributes.

This action is valid for numeric, string, and date values.

Best Practice: Combine this action with a mandatory condition to ensure validity of index fields in subscribing systems.

Answer 1

Is there any error your are getting when you are defining the Rule ? I tried a Sample and it was working for me

Answer 2

Does the problem happen when you specify "must be unique" rule with one Datetime attribute or does it happen when you combine Datetime attribute and Numeric attribute?

Please let me know the detail condition to reproduce the issue.