topic Re: extract date only in App Development

extract date only

victor_greffet — Wed, 29 Nov 2017 12:28:22 GMT

Hi community,

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 ?

Thanks,

Victor

avkeep01 — Wed, 29 Nov 2017 12:40:07 GMT

Hi Victor,

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

victor_greffet — Wed, 29 Nov 2017 12:52:13 GMT

thanks, you save my life

I use the DATE(FLOOR(Date),'DD/MM/YYYY') AS FinalDate...