Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date formating issue?


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.

10 Replies
anbu1984
Master III
Master III

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 ];