Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

akpofureenughwu
Contributor II

Date Flooring

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Date Flooring

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'";

2 Replies
MVP
MVP

Re: Date Flooring

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
Contributor II

Re: Date Flooring

Thank you Sunny