Unable to convert the text to datetime using the format: 'dd-MM-yyyy hh:mm'

Question

Veerle Kohlen 2020-11-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/662043-unable-to-convert-the-text-to-datetime-using-the-format-dd-mm-yyyy-hh-mm

评论： Veerle Kohlen 2020-11-25

采纳的回答： Stephan

Hello,

I am trying to convert a my data set in the format seen below into a datetime:

t = datetime(x([9:2445], 1), 'InputFormat', 'dd-MM-yy hh:mm', 'Format', 'hh:mm');

If the data was collected AM, i.e. 22-9-2020 10:35, then the data is converted using date time.

However, if the data was collected PM, i.e. 22-9-2020 15:48, then Matlab gives the error:

Unable to convert the text to datetime using the format: 'dd-MM-yyyy hh:mm'

This is how I load the data:

[x y z] = xlsread(['C:\Users\veerl\Documents\RM HMS\Year 2\Data\Data Collection\nw1\nw1_cosinuss.xlsx']); x = y;

t = datetime(x([9:2445], 1), 'InputFormat', 'dd-MM-yy hh:mm', 'Format', 'hh:mm');

cosinuss.nw1 = struct('Time', t, 'Temperature', str2double(y([9:2445], 3)));

Can someone see where my mistake in understanding the format of the date is? If so please could you provide a solution that will help me read this format of string into a datetime?

Cheers!

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

请先登录，再进行评论。

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

Answer 1

Stephan 2020-11-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/662043-unable-to-convert-the-text-to-datetime-using-the-format-dd-mm-yyyy-hh-mm#answer_555898

在 MATLAB Online 中打开

datetime('22-9-2020 10:35','InputFormat','dd-MM-yy HH:mm')
datetime('22-9-2020 15:48','InputFormat','dd-MM-yy HH:mm')
ans = 
  datetime
   22-Sep-2020 10:35:00
ans = 
  datetime
   22-Sep-2020 15:48:00