Displaying dates correctly

[#1]

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 · Accepted solution]

How about this may be

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

[#3]

Thanks a lot.

This works just the way I want it