Discussion Board for collaboration on QlikView Scripting.
Dear all ,
I have the attached data in my xls file. I want to conver the date format to YYYY-MM-DD using the below function but not works.
=date#(date#(exceldatetimefiled, 'MM/DD/YYYY hh:mm'),'YYYY-MM-DD')
Output looking for is :
Kindly help me.
Hi Neeru K,
Make use of the makedate() function along with subfield.
your script should look something like:
Many thanks for your answer.
following is works for my case as Qlikview is reading data as DD/MM/YY hh:mm format I had to use below.
date(Date#([Created Date],'DD/MM/YYYY hh:mm'),'YYYY-MM-DD') as %DateKey
Create a JS function on Edit Module.