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.