Seperate yyyymm to mm-yyyy

I uploaded a table with one of the columns showing yyyymm,

How do I get tha column in the mm-yyyy format

Answer 1

[Star Strider]

Try this:

ym = [201910
      201911
      201912
      202001];                      % Numeric (?)

yms = compose('%6d',ym)
my = datetime(yms, 'InputFormat','yyyymm', 'Format','mm-yyyy')

producing:

my = 

  4×1 datetime array

   10-2019
   11-2019
   12-2019
   01-2020

[Megan Mirkhanian]

so my file that I uploaded is called Data

and Data includes three columns, the first column has the yyyymm format. How do I tell matlab to only work with column 1?

[Star Strider]

It would help to have your ‘Data’ file.

That aside, (and assuming that ‘Data(:,1)’ is numeric, since that sstill has not been revealed), try this:

yms = compose('%6d',Data(",1));
my = datetime(yms, 'InputFormat','yyyymm', 'Format','mm-yyyy');

That should work, and also will produce a datetime array.

[Megan Mirkhanian]

This is how the table looks

thank you!

[Walter Roberson]

Data.Var1 = datetime(Data.Var1, 'InputFormat', 'yyyymm', 'Format', 'mm-yyyy');

[Star Strider]

@Walter — Thank you!

[Stephen23]

Note that for datetime objects lowercase mm represents minutes and uppercase MM represents months:

https://www.mathworks.com/help/matlab/ref/datetime.html#buhzxmk-1-Format

It is very unlikely that the data really encoded a timestamp of "yearminute" which should then be displayed as "minute-year". Because the datetime format capitalization is not very intuitiive, it is worth reading/checking the datetime documentation every time, to easily avoid these kind of bugs.