Why am I getting the following datetime error message?

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

Answer 1

[Eric Sofen]

I think it's just a typo in your timestamp format spec: ss.sssZ should be ss.SSSZ

[Gen Gemond]

That did the trick, thank you so much!!!