2 Replies Latest reply: Apr 10, 2017 10:26 AM by Akpofure Enughwure RSS

    Date Flooring

    Akpofure Enughwure

      Good day everyone

       

      My Date format is in this format: YYYY/MM/DD hr/mm/ss

       

      I just

      LOAD date(floor("Date"),'YYYY/MM/DD', 'DD/MM/YYY') as [Project Date],

          asst as [Project asst] ,

          Community as [Project Community],

          "Project Status";

      SQL SELECT "Date",

          OML,

          Community,

          "Project Status"

      FROM CRD.dbo."'Complete Progress'";

       

       

       

      I got this YYYY/MM/DD  but my desired format is   DD/MM/YYYY

       

      I used this

      LOAD date(date#(floor("Date"),'YYYY/MM/DD') as [Project Date],

          asst as [Project asst] ,

          Community as [Project Community],

          "Project Status";

      SQL SELECT "Date",

          OML,

          Community,

          "Project Status"

      FROM CRD.dbo."'Complete Progress'";

       

      but it wasn't  successful

       

      Regards

      Akpofure