different date functions

[nagasekhar]

LOAD * Inline [

date,sales
23-10-2018,100
20/11/2018,200
15-12-2018,300
18 jul 2018,400

];

how to convert this into single date format

[arulsettu · Accepted solution]

Maybe like this

load Date(Alt(Date#(date,'DD-MM-YYYY'),Date#(date,'DD/MM/YYYY'),Date#(date,'DD MMM YYYY')),'DD-MM-YYYY') as Date;

[marcus_sommer · Accepted solution]

Try it with:

alt(date(date#(YourDate, 'Format1')), date(date#(YourDate, 'Format2')), ....)

- Marcus