topic Re: Date Format issue in QlikView

Date Format issue

kakani87 — Sat, 06 Jan 2018 08:23:29 GMT

Hi Folks,

Issue in loading Date field.

I'm pulling a date field from my data base where it returns a number for that used following in script all are displayed in number format.

//date(Dt,'YYYY-MM-DD') as tran_date,

//Dt as tran_date,

//date(Dt) as tran_date,

//Date(Date#(Dt),'DD/MM/YYYY') as tran_date,

floor(date(Dt)) as tran_date,

when I'm considering floor() then as well it is returning number only but now in front end while using date dimension applied date(tran_date) and able to display the correct date value only when used floor () it can be done in my scenario.

Now the issue is with while filtering the date it is displaying number format as '43101' , as per the requirement a current selection box to be used and while filtering the date it is displaying the number but not the date format.

Re: Date Format issue

Anil_Babu_Samineni — Sat, 06 Jan 2018 08:29:46 GMT

May be this?

Date(floor(Dt)) as tran_date,

Date(floor(Date(Dt))) as tran_date,

Re: Date Format issue

kakani87 — Sat, 06 Jan 2018 08:32:06 GMT

My intention is to let you people know that only when i use floor () then i can format that number to date in front end

Re: Date Format issue

kakani87 — Sat, 06 Jan 2018 08:34:33 GMT

Thank you this is working Anil ...