Date formating issue?

[#1]

Hi folks,

I have date values like below.

Date field

2/01/2011

02/01/2011

03/01/2011

04/01/2011

05/01/2011

5/1/2011

here once i loaded all the data into qlikview.i am getting some date format issues.in date field list box i am getting the

02/01/2011 and 2/01/2011 (but both are same)

05/01/2011 and 5/1/2011 (but both are same)

can u plz give me idea on it how can i convert this dates into one format only.

[PrashantSangle]

Hi,

Use date(Date#(DateField,'D/M/YYYY'),'DD/MM/YYYY')

Regards

[Gabriel]

Hi,

Read http://community.qlik.com/blogs/qlikviewdesignblog/2014/12/02/the-date-function

[anbu1984]

Load distinct Right('0' & Date,10) As Date Inline [

Date

2/01/2011

02/1/2011

02/01/2011

03/01/2011

04/01/2011

05/01/2011

5/1/2011 ];

[#5]

I tried but it is not giving the proper result

[PrashantSangle]

Hi,

use Date(Alt(

Date#(DateField,'D/M/YYYY'),

Date#(DateField,'DD/MM/YYYY')

),'DD/MM/YYYY')

Regards

[#7]

hi,

thanks for ur reply

but 5/1/2011 how can i get it?

the above logic vl not for the 5/1/2011 i guess

[PrashantSangle]

Hi,

Try my reply with alt()

This will surely work.

Regards

[#9]

Hi,

You can try this in script .

Dates:

Load * Inline [

dates

2/01/2011

02/01/2011

03/01/2011

04/01/2011

05/01/2011

5/1/2011

];

temp:

LOAD

Date(Date#(dates,'d/mm/yyyy'),'dd-mm-yyyy') as  date

Resident Dates;

[#10]

Hi,

You can try in list box also.