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


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.


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

About cumulative updates for SQL Server
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.


Learn about the terminology Microsoft uses to describe software updates.

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