Empty date in database - convert in QlikView

[#1]

Hello everybody,

I have the following problem: I get the data for the QlikView application through a SQL database. I made a table in QlikView where some information is shown, e.g. the Name of the product, how much it costs and a scheduled datum (see attached screenshot).

Unfortunately, QlikView does not handle empty date fields in the SQL database and therefore shows the date 31.12.4294967295. I would like the fields in QlikView being empty, when no date is found in the database (e.g. like in the column "Güte": for "Schneidkosten" there is no "Güte" information and therefore the fields stay empty).

I would appreciate any idea!

Thanks, Alisa

[tamilarasu · Accepted solution]

Hi Alisa,

Something like below,

ALT(DATE#( Date,'DD-MM-YYYY' ),'Not valid' )

Let me know.

[#3]

Hello Tamil,

Thanks for your quick answer! Your suggestion was kind of "right", but it didn't work because of the database. Apparently there is some update which is responsible for this problem, otherwise it would have worked. I am working on this now with our IT-guys.

Anyway, I appreciate your help!