Date Format Help

[niharikab]

Hi Experts,

Can any one please help me to convert the below multiple date formats into DD-MM-YYYY Format.

I have tried like below but all are getting in DD/MM/YYYY format when i have changed DD-MM-YYYY also its showing DD/MM/YYYY only.

Date(alt(SalesDate,Date#(SalesDate,'DD-MM-YYYY'),Date#(SalesDate,'DD/MM/YYYY'),Date#(SalesDate,'DD.MM.YYYY'),'DD-MM-YYYY')) AS [Date]

Calender:
Load *,
Date(alt(SalesDate,Date#(SalesDate,'DD-MM-YYYY'),Date#(SalesDate,'DD/MM/YYYY'),Date#(SalesDate,'DD.MM.YYYY'),'DD/MM/YYYY')) AS [Date]

Inline [
SalesDate,Sales
01-02-2015,100
02/03/2016,200
03.04.2017,300

];

Please help me on this.

Thanks in advance. 

[tresesco · Accepted solution]

Try this:

Calender:
Load *,
Date(alt(SalesDate,Date#(SalesDate,'DD-MM-YYYY'),Date#(SalesDate,'DD/MM/YYYY'),
Date#(SalesDate,'DD.MM.YYYY')),'DD-MM-YYYY') AS [Date]

Inline [
SalesDate,Sales
01-02-2015,100
02/03/2016,200
03.04.2017,300

];