Date Flooring

[akpofureenughwu]

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

[sunny_talwar · Accepted solution]

May be this

LOAD Date(Floor("Date"), 'DD/MM/YYYY') 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'";

[akpofureenughwu]

Thank you Sunny