Clear Filters
Clear Filters

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

3 views (last 30 days)
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!

Accepted Answer

Star Strider
Star Strider on 22 Jun 2014
Edited: Star Strider on 22 Jun 2014
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

More Answers (0)

Categories

Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!