Date column combining D/M/Y and M/D/Y dates

[osabhaois]

I am combinging two data sets with dates D/M/Y and M/D/Y 

My data throws errors when I attempt to combine.

Is there a clean way to do this.

I dont think setting locale is an option as it will always contradict one of the date sets

thanks

[lbendlin]

do both data sources have mixed format , or is one on D/M/Y and the other on M/D/Y ?

If the former then you are totally and utterly out of luck. If the latter then you can apply the locale to each of the data sources before combining them.