Problem with date data 0000-00-00 with ODBC

[TomK8]

Hi,

I come to you because I have encountered data interpretation problems on Qlik since the last release.

This concerns data with DATE type which are not mandatory in my database (MYSQL) and which have the value '0000-00-00'.

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.

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.

I have been browsing the forum since the beginning of the week but I have not found any solutions to my problem.

I had no problem before the last release of May 2022.

Thank you in advance for your help😊

(Sorry for my English)

[johngouws]

I am not sure if you have tried using Date# yet. 

Otherwise, I am not sure if this will help. I recently had a similar problem and got around it by using

CAST((Date) AS date) as Date, in the sql side of the extract.