Can i take correct date from this data?

1 view (last 30 days)
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
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

Sign in to comment.

Accepted Answer

the cyclist
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
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')

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!