problem with datenum

5 views (last 30 days)
Lu
Lu on 20 Apr 2011
Hi everybody!!
I have one quick question. I´m trying to convert the dates and the timestamps of my .mat file into numbers using datenum. Dates and timestamps are in different columns, but the problem is that when I type
date=dataFile(:,1);
timestamp=dataFile(:,2);
datenumber=datenum(date,'dd.mm.yy');
timestampnumber=datenum(timestamp,'dd.mm.yy');
I get the message error
??? Error using ==> datenum at 182
DATENUM failed.
Caused by: Error using ==> datevec at 110 The input to DATEVEC was not an array of strings.
However, if I type
datafile=(finalData{:,2});
data2num=datenum(datafile);
it works but just for the first element of the dates, but I need all the elements not just one. Do you have any ideas how can I solve this?
Just one extra detail, when I type whos this is what i get
EDU>> whos date timestamp
Name Size Bytes Class Attributes
date 31591x1 4296376 cell
timestamp 31591x1 4296376 cell
I hope you could help me out with this problem
thank you and have a nice day :)
  6 Comments
Lu
Lu on 20 Apr 2011
Thank you for pointing this out! I didnt know that but I sure wrote stuff starting with apostrophe! :)

Sign in to comment.

Accepted Answer

Laura Proctor
Laura Proctor on 20 Apr 2011
I believe that the error is being thrown when you are trying to create datenumber. This could be because date contains a cell array of cells. Try the following code to see if this works:
datenumber = datenum([date{:}],'dd.mm.yy');
  2 Comments
Laura Proctor
Laura Proctor on 20 Apr 2011
I'm so glad we were able to finally get to a resolution! Good luck with your work. :o)

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!