filtering problem of dates

Question

AA 2017-11-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/364473-filtering-problem-of-dates

回答： Cam Salzberger 2017-11-1

   circa1 = xlsread(fileToRead);
  [numOnly, textOnly, rawDataInCellArray] = xlsread(fileToRead);
  Dates=textOnly(~cellfun('isempty',textOnly));
     matchresult = regexp(Dates, '(?<day>\d+)/(?<month>\d+)/(?<year>\d+)');
     nomatch = cellfun(@isempty, matchresult);
    dateless = Dates(nomatch);
      datelike = Dates(~nomatch);
       dateliketime=datetime(datelike);
   liatime=dateliketime.Month == 10;
Warning: Successfully read the date/time strings using the format 'MM/dd/uuuu', but their format is ambiguous and could also be
'dd/MM/uuuu'. Specify a format string to avoid ambiguity. 
> In guessFormat (line 59)
  In datetime (line 589)

I get the above error. The filtering is wrong because the format string is not properly defined. I want dd/MM/uuuu. I cannot filter out the month October successfully.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Cam Salzberger 2017-11-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/364473-filtering-problem-of-dates#answer_288836

在 MATLAB Online 中打开

As the warning suggests, try specifying the correct 'InputFormat' when you call datetime.

datelike = {'01/10/2017' ; '02/10/2017'};
dt = datetime(datelike)
Warning: Successfully read the date/time text using the format 'MM/dd/uuuu', but their
format is ambiguous and could also be 'dd/MM/uuuu'. Specify a format character vector
to avoid ambiguity. 
> In guessFormat (line 66)
  In datetime (line 612) 
dt = 
  2×1 datetime array
   10-Jan-2017
   10-Feb-2017

versus:

datelike = {'01/10/2017' ; '02/10/2017'};
dt = datetime(datelike, 'InputFormat', 'dd/MM/uuuu')
dt = 
  2×1 datetime array
   01-Oct-2017
   02-Oct-2017