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.

[anbu1984]

I dont know how, but it works for 5/1/2011 using Right()

Load distinct Right('0' & Date,10) As Date,Date(Date#(Date,'MM/DD/YYYY'),'MM/DD/YYYY') As Date1 Inline [

Date

2/01/2011

02/1/2011

02/01/2011

03/01/2011

04/01/2011

05/01/2011

5/1/2011 ];