https://community.qlik.com/t5/Connectivity-Data-Prep/Problem-with-date-data-0000-00-00-with-ODBC/m-p/1945087#M10941 <P>Hi,</P> <P>I come to you because I have encountered data interpretation problems on Qlik since the last release.</P> <P>This concerns data with DATE type which are not mandatory in my database (MYSQL) and which have the value '0000-00-00'.</P> <P>The connection is made in ODBC. When I try to import the data with a csv file I don't have any problems, they are imported with the values ​​'0000-00-00' and then I apply a date() to put them in date format.</P> <P>All the fields linked to these DATE data are distorted and the calculations wrong as soon as I try to integrate one of these fields.</P> <P>I have been browsing the forum since the beginning of the week but I have not found any solutions to my problem.</P> <P>I had no problem before the last release of May 2022.</P> <P>Thank you in advance for your help<span class="lia-unicode-emoji" title=":smiling_face_with_smiling_eyes:">😊</span></P> <P>(Sorry for my English)</P> Fri, 17 Jun 2022 14:08:47 GMT TomK8 2022-06-17T14:08:47Z https://community.qlik.com/t5/Connectivity-Data-Prep/Problem-with-date-data-0000-00-00-with-ODBC/m-p/1945087#M10941 <P>Hi,</P> <P>I come to you because I have encountered data interpretation problems on Qlik since the last release.</P> <P>This concerns data with DATE type which are not mandatory in my database (MYSQL) and which have the value '0000-00-00'.</P> <P>The connection is made in ODBC. When I try to import the data with a csv file I don't have any problems, they are imported with the values ​​'0000-00-00' and then I apply a date() to put them in date format.</P> <P>All the fields linked to these DATE data are distorted and the calculations wrong as soon as I try to integrate one of these fields.</P> <P>I have been browsing the forum since the beginning of the week but I have not found any solutions to my problem.</P> <P>I had no problem before the last release of May 2022.</P> <P>Thank you in advance for your help<span class="lia-unicode-emoji" title=":smiling_face_with_smiling_eyes:">😊</span></P> <P>(Sorry for my English)</P> Fri, 17 Jun 2022 14:08:47 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Problem-with-date-data-0000-00-00-with-ODBC/m-p/1945087#M10941 TomK8 2022-06-17T14:08:47Z https://community.qlik.com/t5/Connectivity-Data-Prep/Problem-with-date-data-0000-00-00-with-ODBC/m-p/1946027#M10951 <P>I am not sure if you have tried using Date# yet.&nbsp;</P> <P>Otherwise, I am not sure if this will help. I recently had a similar problem and got around it by using</P> <P>CAST((Date) AS date) as Date, in the sql side of the extract.&nbsp;</P> <P>&nbsp;</P> Tue, 21 Jun 2022 06:19:35 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Problem-with-date-data-0000-00-00-with-ODBC/m-p/1946027#M10951 johngouws 2022-06-21T06:19:35Z