topic Re: Format of Date in QlikView

Format of Date

mohan2391 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a date field as below.

How to change the format of this field to "DD/MM/YYYY" ?

Thank You....

Re: Format of Date

Chanty4u — Fri, 09 Dec 2016 09:38:31 GMT

try like below

LOAD * INLINE [

Mydate

20150815

20160912

];

Result:

LOAD *,

Date(date#(Mydate,'YYYYMMDD'),'YYYY/MM/DD') AS newDate

Resident a;

Re: Format of Date

jjbom1990 — Fri, 09 Dec 2016 09:46:38 GMT

In your load script:

date(Right(REV_REC_DAY,2)&'-'&Mid(REV_REC_DAY,5,2)&'-'&left(REV_REC_DAY,4),'DD/MM/YYYY') as REV_REC_DAY

Re: Format of Date

jjbom1990 — Fri, 09 Dec 2016 09:48:25 GMT

This solution is a bit cleaner.

Re: Format of Date

Anonymous — Fri, 09 Dec 2016 09:51:53 GMT

Hi,

Use this in load script Date(Floor(REV_REC_DAY),'DD/MM/YYYY') as REV_REC_DAY

-Sweta

Re: Format of Date

dineshm030 — Fri, 09 Dec 2016 09:56:24 GMT

Hi,

You can this in Expression Area:

=Date(Date#(REV_REC_DAY,'YYYYMMDD'),'DD/MM/YYYY') as REV_REC_DAY

Re: Format of Date

Fri, 09 Dec 2016 09:58:44 GMT

Use the below in your script

Re: Format of Date

Fri, 09 Dec 2016 09:59:03 GMT

Use the below in your script

Date(Date#(REV_REC_DAY,'YYYYMMDD'),'DD/MM/YYYY')

Re: Format of Date

mohan2391 — Fri, 09 Dec 2016 09:59:30 GMT

It has given some wrong data for Year.

Re: Format of Date

nitin_01 — Fri, 09 Dec 2016 10:01:34 GMT

Hi Mohan,

Try this:

Date(TimeStamp#(REV_REC_DAY),'YYYYMMDD'),'DD/MM/YYYY')

Regards,

Nitin

Re: Format of Date

mohan2391 — Fri, 09 Dec 2016 10:04:00 GMT

It is not showing anything in list box.

Re: Format of Date

jjbom1990 — Fri, 09 Dec 2016 13:45:49 GMT

Using the example of chanty4u‌ :

LOAD * INLINE [

Mydate

20150815

20160912

];

Result1:

LOAD *,

date(Right(Mydate,2)&'-'&Mid(Mydate,5,2)&'-'&left(Mydate,4),'DD/MM/YYYY') as Date

Resident a;

Result:

LOAD *

,year(Date) as Year

,month(Date) as Month

,day(Date) as Day

Resident Result1;

Drop table a;

drop table Result1;

I don't know what went wrong on your side, but my code worked.

Re: Format of Date

praveenkumar_s — Sat, 10 Dec 2016 06:41:24 GMT

try this,

Date(REV_REC_DAY,'MM/DD/YYYY') as REV_REC_DAY