How to change the date format by not misplacing days with months?
3 views (last 30 days)
Show older comments
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!
0 Comments
Accepted Answer
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)
See Also
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!