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.
12,896 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.
495 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,611 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.