Discussion Board for collaboration on QlikView Scripting.
Good day everyone
My Date format is in this format: YYYY/MM/DD hr/mm/ss
LOAD date(floor("Date"),'YYYY/MM/DD', 'DD/MM/YYY') as [Project Date],
asst as [Project asst] ,
Community as [Project Community],
SQL SELECT "Date",
FROM CRD.dbo."'Complete Progress'";
I got this YYYY/MM/DD but my desired format is DD/MM/YYYY
I used this
LOAD date(date#(floor("Date"),'YYYY/MM/DD') as [Project Date],
but it wasn't successful
Go to Solution.
May be this
LOAD Date(Floor("Date"), 'DD/MM/YYYY') as [Project Date],
Thank you Sunny