Convertion of diff date format in to unique format

[#1]

Hi All,

I have date field in the attached excel. it is in DD-MM-YYYY and in string format. i need to convert everything in to DD-MM-YYYY format.

For Instance in the attached excel i have 01-08-2013, 01-09-2013 and some string dates like 15/01/2013 , 16/01/2013 but all are belongs to january month.

Expected result is 08-01-2013, 09-01-2013, 15-01-2013, 16-01-2013

Kindly help me to resolve this.

Thanks in Advance.

Mahi.

[manideep78]

LOAD    date(Alt(Date#(A,'DD/MM/YYYY'),Date#(A,'DD-MM-YYYY'),Date#(A,'MM-DD-YYYY'),Date#(A,'MM/DD/YYYY'))) as A,

     B

FROM

C:\Users\Manideep\Downloads\date.xlsx

(ooxml, no labels, table is Sheet1);