Change Date Format

[DrGenious]

Hello,

Lets consider that we input files and they dont have the same date format. I want when I import them to change their date format.. For example We import a file with date format MM/dd/yy , another one with format yyyy/MM/dd and I want both of them to have the format of dd/MM/yyyyy. Thanks.

[fdenis]

so first detect date format, then convert to yours.

the best yay is to convert to date first then convert to string with format.