Master Data Services: Weird automatic Date conversion

ErikJan 1 Reputation point
2021-02-08T16:06:12.387+00:00

After migrating to MDS2019 there is now an issue when adding members to our entities. We have a datetime column with an input mask dd/mm/yyyy, however when adding a member and filling in the date a weird automatic conversion happens. Everything works fine when filling in dates till the 28th of the month (e.g. 28/12/2020), however continuing these dates filling in 29/12/2020, 30/12/2020 and 31/12/2020 automatically changes to 01/12/2020, 02/12/2020 and 03/12/2020 respectively. This does not happen when filling in the date in American format (MM/dd/yyyy) altough the inputmask definitely is dd/mm/yyyy. Is there someone who knows how this occurs?

Best,
Erik Jan

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,788 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,626 Reputation points
    2021-02-09T02:28:37.7+00:00

    Hi,

    If this problem only occurs after the migration, please try to apply the latest updates for your SQL Server instance to avoid some problems that have been proven and fixed.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.