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

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

About cumulative updates for SQL Server
About cumulative updates for SQL Server

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.
Properties

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

Feedback