Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Date Field not working

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!


3 Replies
sunny_talwar
Not applicable

Re: Date Field not working

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
Not applicable

Re: Date Field not working

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
Not applicable

Re: Date Field not working

try

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