topic Re: Date Field not working in QlikView

Date Field not working

Tue, 22 Mar 2016 12:40:36 GMT

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 — Tue, 22 Mar 2016 12:46:55 GMT

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 — Tue, 22 Mar 2016 12:47:28 GMT

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 — Tue, 22 Mar 2016 12:50:35 GMT

try

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