Can i take correct date from this data?
1 view (last 30 days)
Show older comments
Kostiantyn Voskoboinik
on 21 Apr 2020
Commented: Kostiantyn Voskoboinik
on 21 Apr 2020
Hello, i tried to convert my dates from string format to correct date, but i get errors.Can i convert it?
2 Comments
the cyclist
on 21 Apr 2020
Edited: the cyclist
on 21 Apr 2020
It is much more helpful if you upload the data in a MAT file (using the paper-clip icon) than as a screenshot, which we cannot work with directly.
Is your data format equivalent to this?
t = {'Jan 2020','Dec 2019'}; % and so on
Accepted Answer
the cyclist
on 21 Apr 2020
Edited: the cyclist
on 21 Apr 2020
You need to be precise with the format string.
Try
datetime(t,'InputFormat','MMM yyyy')
2 Comments
the cyclist
on 21 Apr 2020
Edited: the cyclist
on 21 Apr 2020
In the file you uploaded, your data are in a table, so to use this solution, you'd need to convert it first. (It looks like you've already converted in your workspace, since the screenshot shows that it is a cell.)
datetime(table2cell(t),'InputFormat','MMM yyyy')
More Answers (0)
See Also
Categories
Find more on Time Series Objects in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!