topic Re: Date Flooring in QlikView

Date Flooring

akpofureenughwu — Mon, 10 Apr 2017 13:44:43 GMT

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 — Mon, 10 Apr 2017 13:48:21 GMT

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 — Mon, 10 Apr 2017 14:26:14 GMT

Thank you Sunny