Inconsistent data if you add a date that is before March 1, 1900 in the MDS add-in for Excel in SQL Server 2016 RRS feed

  • Question

  • You use the Master Database Service (MDS) add-in for Excel in Microsoft SQL Server 2016. 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.

    I can find Microsoft patch update for sql server 2014, but could not find anything for 2016.


    Can you please help?

    Thanks in advance

    Monday, May 13, 2019 4:18 AM

All replies

  • Hi Guys

    Any help with the above mentioned issue, as I am not able to find for a permanent fix for this problem.


    Thursday, May 16, 2019 4:02 AM