Problem with input for the datetime function

Question

0 个投票

I have a cell array containing strings that describe a date. It looks like this:

datum=
    '01.06.2014'
    '02.06.2014'
    '03.06.2014'
    '04.06.2014'
    '05.06.2014'

I want to convert them to a Matlab recognised date array, so that I can ultimately determine in which Calender Week they fall in (using the function week)

My code looks like this:

%reading in the data file and isolating the weekday column 
dateiname='ABGERUFENE_SRL_BETR_IST-WERTE_20140601_20140630_Netzregelverbund_20150408-225302.CSV';
  [num text raw]=xlsread(dateiname);
  raw([1 2 3 4 5],:) = [];
  datum=raw(:,1)
%conversion into date
  datum=datetime(datum, 'InputFormat','dd.mm.yyyy');

However this returns the error message: ??? Undefined function or method 'datetime' for input arguments of type 'cell'. It should be able to handle a string, so I don't understand the problem. I have used the query

iscellstr(datum)

which returns a 1, so I really don't know why the error appears. I have also tried using the "text" data - that doesn't work either.

Any help troubleshooting will be much appreciated!!!!!

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Guillaume 2015-7-9

Your datum is not a string, it's a cell array of string. These are two different types. It should not matter however, as datetime can handle both types.

Which version of matlab are you using?

Also note that your input format is wrong, it should be: 'dd.MM.yyyy'. datenum and datetime use different format symbols for minutes and months)

请先登录，再进行评论。

请先登录，再回答此问题。

Follow Question