Why am I getting the following datetime error message?

8 visualizzazioni (ultimi 30 giorni)
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

Risposta accettata

Eric Sofen
Eric Sofen il 3 Dic 2021
I think it's just a typo in your timestamp format spec: ss.sssZ should be ss.SSSZ

Più risposte (0)

Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

Prodotti


Release

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by