Cannot use datetime function on {'01 Nov 2019 14:39:50.365'}
14 views (last 30 days)
Show older comments
Results in following error: Could not recognize the date/time format of '01 Nov 2019 14:39:50.365'. You can specify a format using the 'InputFormat' parameter. If the date/time text contains day, month, or time zone names in a language foreign to the 'en_US' locale, those might not be recognized. You can specify a different locale using
the 'Locale' parameter.
I've tried pretty much everything, what i'm after is converting the above date into juilian time. The juliandate function does not work on the date either.
0 Comments
Accepted Answer
the cyclist
on 20 Jan 2020
s = '01 Nov 2019 14:39:50.365';
datetime(s,'InputFormat',"dd MMM yyyy HH:mm:ss.S")
2 Comments
NN
on 10 Mar 2021
Hi , i use this below code and not able to change the date from Dec 31 1899. .Fig image is attached.I would like to change the date from Dec 31 1899 to 17 Feb 2020
Please help .
clc
y=xlsread('time.xlsx');
plugin=y((1:end),8)';
outd = datetime(s,plugin, 'convertfrom', 'excel');
figure
plot(outd)
More Answers (0)
See Also
Categories
Find more on Data Type Identification in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!