FIX: Inconsistent data if you add a date that is before March 1, 1900 in the MDS add-in for Excel in SQL Server 2014

S’applique à : SQL Server 2014 Business IntelligenceSQL Server 2014 Business IntelligenceSQL Server 2014 Developer

Symptoms


You use the Master Database Service (MDS) add-in for Excel in Microsoft SQL Server 2014. When you change or add a date in the Excel Add-in that is before March 1, 1900, you find that the MDS database contains the date minus one day. This problem leads to inconsistent data.

Resolution


This problem was first fixed in the following cumulative update for SQL Server:

Cumulative Update 1 for SQL Server 2014 SP1

Cumulative Update 7 for SQL Server 2014

Status


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

References


Learn about the terminology Microsoft uses to describe software updates.