How to change the date format by not misplacing days with months?

Dear all,

I have a huge dataset with dates in the first column of the array (lets call it 'myarray'). My date in the first column of "myarray" is displayed as follows: '1-12-13 21:34' '1-12-13 21:35' '1-12-13 21:36' However, I want to change the format of my dates to two-digits days, i.e. 'dd-mm-yy HH:MM'.

But when I executed this code: myarray= cellstr(datestr(myarray(:,1),'dd-mm-yy HH:MM'));

The dates became: '12-01-13 21:34' '12-01-13 21:35' '12-01-13 21:36'

My original date is 1st of December, but the dates became 12th January... Can anyone help me make them the correct date? with format dd-mm-yy.

Thank you very much!

Answer 1

[Star Strider]

See if this does what you want:

DateTime = {'1-12-13 21:34' '1-12-13 21:35' '1-12-13 21:36'};
NewDate = datestr(datenum(DateTime, 'dd-mm-yy HH:MM'), 'dd-mm-yy HH:MM')

produces:

NewDate =

01-12-13 21:34
01-12-13 21:35
01-12-13 21:36

[B.kun]

Oh yes, it worked now! Thank you so much!!

[Star Strider]

My pleasure!