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

    (https://support.microsoft.com/en-us/help/3046893/fix-inconsistent-data-if-you-add-a-date-that-is-before-march-1-1900-in)

    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.

    Cheers


    Thursday, May 16, 2019 4:02 AM