Why am I getting the following datetime error message?

Question

Gen Gemond 2021-12-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1601820-why-am-i-getting-the-following-datetime-error-message

评论： Gen Gemond 2021-12-3

采纳的回答： Eric Sofen

RSPB_MAGNETOMETER2.xlsx

在 MATLAB Online 中打开

Hello all,

Here is the message I am receiving:

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

I am pretty confused about this, as I have an array of UTC dates (and these are strings) that look like the following:

'2017-09-05T00:00:31.256928000Z'

And, so far as I know, this looks just like the format datetime requires. Could someone please point me in the right direction as to what is going wrong? Thank you in advance!! :)

My file is attached, and here is my code:

filename = 'RSPB_MAGNETOMETER2.xls'; %data courtesy of NASA SPDF, Craig Kletzing
A2 = readtable(filename);
Brms2 = table2array(A2(:,2));
dateVec2 = table2array(A2(:,1));
dates2 = datetime(dateVec2,'InputFormat','yyyy-MM-dd''T''hh:mm:ss.sssZ','TimeZone','UTC');
figure(2)
hold on
ylim([0, 100])
xlim([0, 65536])
plot(dates2, Brms2)
xlabel('counts')
ylabel('B_(rms), nT')
hold off