Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mohan2391
Creator II
Creator II

Format of Date

Hi,

I have a date field as below.

sssss.PNG

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

Thank You....

1 Solution

Accepted Solutions
Chanty4u
Champion III
Champion III

try like below

a:

LOAD * INLINE [

    Mydate

    20150815

    20160912

];

Result:

LOAD *,

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

Resident a;

dat.PNG

View solution in original post

12 Replies
Chanty4u
Champion III
Champion III

try like below

a:

LOAD * INLINE [

    Mydate

    20150815

    20160912

];

Result:

LOAD *,

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

Resident a;

dat.PNG

View solution in original post

jjbom1990
Creator
Creator

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

jjbom1990
Creator
Creator

This solution is a bit cleaner.

swetafuria02
Contributor II
Contributor II

Hi,

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

-Sweta

dineshm030
Creator II
Creator II

Hi,

You can this in Expression Area:

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

Not applicable

Use the below in your script

Not applicable

Use the below in your script


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

mohan2391
Creator II
Creator II
Author

It has given some wrong data for Year.

nitin_01
Creator
Creator

Hi Mohan,

Try this:

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

Regards,

Nitin