2 Replies Latest reply: Nov 29, 2017 7:53 AM by Victor GREFFET RSS

    extract date only

    Victor GREFFET

      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 :

      • date(Date) as FinalDate
      • date#(Date,'<DD/MM/YYYY>') as FinalDate

      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