Discussion Board for collaboration related to QlikView Deployment.
I've a date column and a Platform column in my app as below
I'm using the below formulae to convert into date format in Load script and I'm getting the below output
Date(Load_Date,'DD/MM/YYYY') as Load_Date .
But I would like to see something like below.
Go to Solution.
Date(Floor(Load_Date),'DD/MM/YYYY') as Load_Date
LOAD date(floor(date#(Load_Date, 'DD/MM/YYYY hh:mm:ss'))) as Load_Date, Platform FROM [https://community.qlik.com/thread/283231] (html, codepage is 1252, embedded labels, table is @1);
thanks for this, it is working fine now..!!!!