Datenum date conversion troubles
1 view (last 30 days)
Show older comments
I have a matlab file of timestamps called d that looks like this...
'7/31/2012 2:35:00 PM'
'7/31/2012 2:36:00 PM'
'7/31/2012 2:37:00 PM'
'7/31/2012 2:38:00 PM'
'7/31/2012 2:39:00 PM'
'7/31/2012 2:40:00 PM'
and I am trying to put these timestamps into matlab so I can graph the data. so I have tried
CR100.time = datenum(d(:,1),'mm/dd/yyyy HH:MM:SS Ww')
But I am getting the response...
??? Error using ==> datenum at 182 DATENUM failed.
Caused by: Error using ==> dtstr2dtnummx Failed on converting date string to date number.
Any clue how to import these timestamps?
Also do you know how I can save an excel file in a matlab script.
1 Comment
Answers (3)
the cyclist
on 31 Jul 2012
Edited: the cyclist
on 31 Jul 2012
I suspect it is the 'Ww' that is tripping you up. Try
datenum(d,'mm/dd/yyyy HH:MM:SS PM')
0 Comments
Thomas
on 31 Jul 2012
Just try something like:
str={'7/31/2012 2:35:00 PM'
'7/31/2012 2:36:00 PM'
'7/31/2012 2:37:00 PM'
'7/31/2012 2:38:00 PM'
'7/31/2012 2:39:00 PM'
'7/31/2012 2:40:00 PM'}
date_time=datenum(str)
0 Comments
Aaron
on 31 Jul 2012
3 Comments
the cyclist
on 31 Jul 2012
My advice would be to use my code on subset of d [such as d(1:5), then d(6:10), etc] until you can identify some entries of d that are causing the problem.
See Also
Categories
Find more on Time Series Objects 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!