Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I'm facing trouble with date type,
I load date from an excel database., I have that kind of data :
Date |
---|
20/07/2017 08:41:33 |
20/07/2017 |
20/07/2017 08:41:33 |
18/08/2017 |
25/07/2017 |
20/07/2017 10:41:35 |
.... |
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 :
Date |
---|
20/07/2017 |
20/07/2017 |
20/07/2017 |
18/08/2017 |
25/07/2017 |
20/07/2017 |
Do you have an idea ?
Thanks,
Victor
Hi Victor,
assuming that all dates have the same format:
DATE(DAYSTART(Date),'DD/MM/YYYY') AS FinalDate
or
DATE(FLOOR(Date),'DD/MM/YYYY') AS FinalDate
or (a lesser solution)
DATE(LEFT(Date,10),'DD/MM/YYYY') as FinalDate
Hi Victor,
assuming that all dates have the same format:
DATE(DAYSTART(Date),'DD/MM/YYYY') AS FinalDate
or
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...