3 Replies Latest reply: Nov 28, 2017 6:15 AM by Bharath Vikas Shanagonda RSS

    Need help in formating date column

    Bharath Vikas Shanagonda

       

      Hi,

       

      I've a date column and a Platform column in my app as below

       

       

      Load_DatePlatform
      23/11/2017  00:00:00A
      26/11/2017  01:27:55B
      26/11/2017  01:27:56B
      26/11/2017  01:27:57B
      26/11/2017  01:06:07C
      28/11/2017  06:39:24D

       

      I'm using the below formulae to convert into date format in Load script and I'm getting the below output

       

      Date(Load_Date,'DD/MM/YYYY') as Load_Date .

       

      Load_DatePlatform
      23/11/2017 A
      26/11/2017 B
      26/11/2017 B
      26/11/2017 B
      26/11/2017 C
      28/11/2017 D

       

      But I would like to see something like below.

       

      Load_DatePlatform
      23/11/2017  A
      26/11/2017  B
      26/11/2017  C
      28/11/2017  D

       

       

      Regards,

      Vikas