Correct date with swapped year and day values

[Tom]

This question was recently posted on stackoverflow. 

I am working with a dataset containing a date variable with the format MMDDYY10.. The problem is, that the day, month and the year have been swapped.

The data set as it looks now:

Obs Date
1   11/01/1931
2   11/06/1930
3   12/02/2003
4   12/07/2018

What I would like is a date variable with the format DDMMYY10., or a similar:

Obs Date
1   31/01/2011
2   30/06/2011
3   03/02/2012
4   18/07/2012

Observation 1 is hence written as the 1st of November 1931, but really it is the 31st of January 2011.

Does anyone know how I can change this?

[Tom]

data have ;
  input olddate mmddyy10.;
  newdate = input(put(olddate,mmddyy6.),yymmdd6.);
  format olddate newdate yymmdd10. ;
  put (olddate newdate) (=);
cards;
11/01/1931
11/06/1930
12/02/2003
12/07/2018
;;;;

[Tom · Accepted solution]

I am typing this on cell phone. I noticed that the code formatting did display in chrome browser on my cell phone.

[Tom]

It does not seem possible to edit replies on a cell phone.