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

Multiple dates issue

i've date field and other columns. Date fields has multiple date formats for eg it has date in dd/mm/yyyy and mm/dd/yyyy

i want date in dd/mm/yyyy format.  dates in mm/dd/yyyy should also be converted into set format which is dd/mm/yyyy.

Date
12/1/2012
12/2/2012
12/3/2012
25/4/2012
12/5/2012
12/6/2012
22/7/2012
12/8/2012
12/9/2012
12/10/2012
12/11/2012
12/12/2012
12/13/2012
12/14/2012
12/15/2012

In the above table i've 2 date formats. So where month is field is greater then 12 it should take it as date and change the date format otherwise set format for date which is dd/mm/yyyy.

thanks

1 Reply
spsrk_84
Creator III
Creator III

Hi ,

I have taken the dates which you had mentioned in your post & converted different formats into DD/MM/YYYY format.

Please find attached Qvw for your reference.

Thanks,

Shiva