9 Replies Latest reply on Feb 13, 2019 12:06 PM by Tim Dines

    Date formatting incorrectly when connecting to database

    Philip Kanis

      Hi,

       

      I'm trying to connect to a Microsoft SQL Server database however the date fields are coming through as a string and when I convert the type to "Date" they are being read as YYYY-DD-MM instead of YYYY-MM-DD. This results in a large amount of null dates as it excludes any date where the DD is above 12 (as it is reading it as MM).

       

      My Operating System region is correct (YYYY-MM-DD) and this is for 10.1 Desktop

       

      Thank you.