FIX: "Error converting data type nvarchar to datetime" error occurs when you use business rule in SQL Server 2014 MDS


Consider the following scenario:
  • You create a business rule that checks whether a date attribute is empty in Microsoft SQL Server 2014 Master Data Services (MDS).
  • You save and publish the business rule.
  • You open the entity view in MDS Explorer, and then run the business rule to validate the entity members.
In this scenario, you receive the following error message:
Error converting data type nvarchar to datetime.

Note This issue occurs in SQL Server 2014 MDS that has applied Cumulative Update 3 (CU3) or later versions of updates.


The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 1 for SQL Server 2014 SP1

About cumulative updates for SQL Server


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Article ID: 3029504 - Last Review: Jun 22, 2015 - Revision: 1