Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
try
Date(Floor(TimeStamp#([launch date], 'DD-MM-YYYY')),'YYYYMMDD') as launchDate