topic Displaying dates correctly in QlikView

Displaying dates correctly

Thu, 22 Sep 2016 07:56:06 GMT

Hi everyone,

I could need some help with the following:

This is my source data:

To have the dates displayed in the format DD.MM.YYYY I used the following expression in my script, which works nearly perfect.

Date(Date#(VALUE_OLD, 'YYYYMMDD'), 'DD.MM.YYYY') as [Alter Wert BELEG];

However, the value 00000000 is only displayed as " - "

Since I need the date for a follow-up calculation I need it to be displayed as 00.00.0000, therefore getting rid of the sign.

Any suggestions appreciated.

Thanks in advance,

Daniela

sunny_talwar — Thu, 22 Sep 2016 16:07:29 GMT

How about this may be

Alt(Date(Date#(VALUE_OLD, 'YYYYMMDD'), 'DD.MM.YYYY'), Dual('00.00.0000', 0)) as [Alter Wert BELEG];

Thu, 22 Sep 2016 16:30:30 GMT

Thanks a lot.

This works just the way I want it