Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm facing trouble with date type,
I load date from an excel database., I have that kind of data :
In the script I tried :
But it seems that the time is still here...
I want to extract only date DD/MM/YYYY :
I want :
Do you have an idea ?
Go to Solution.
assuming that all dates have the same format:
DATE(DAYSTART(Date),'DD/MM/YYYY') AS FinalDate
DATE(FLOOR(Date),'DD/MM/YYYY') AS FinalDate
or (a lesser solution)
DATE(LEFT(Date,10),'DD/MM/YYYY') as FinalDate
thanks, you save my life
I use the DATE(FLOOR(Date),'DD/MM/YYYY') AS FinalDate...