Date Field not working

[#1]

Hello Friends,

I am try to load a date field applying the logic in QlikView script as stated below :-

Date(Date#([launch date],'YYYY/MM/DD'),'YYYYMMDD') as LaunchDate

The field appears, for example as 21-03-2016 in the source file.

But if I apply the logic is applied as mentioned above, I get empty values for the dimension  LaunchDate,

Any help is highly appreciated!

Thanks!

[sunny_talwar]

You need to match the format with what's coming in your Date#() function.Try this:

Date(Date#([launch date],'DD-MM-YYYY'),'YYYYMMDD') as LaunchDate

[jjbom1990]

you state the the source is as dd-mm-yyyy so the code should be:

Date(Date#([launch date],'DD-MM-YYYY'),'YYYYMMDD') as LaunchDate

[Chanty4u]

try

Date(Floor(TimeStamp#([launch date], 'DD-MM-YYYY')),'YYYYMMDD') as launchDate