MATLAB: Matlab not recognizing dates

dates

I have a vector of dates in the format yyyymm, however matlab is not recognizing it for a timetable. Any suggestions?

You did not mention how you were importing them.

Try importing them this way:

dv = {'202011'
      '202012'}
datetime(dv, 'InputFormat','yyyyMM', 'Format','MM-yyyy')

That works for me.

Try this:

de = ['08/21/2020 (Aug)'; '09/21/2020 (Sep)']
DT = datenum(de, 'mm/dd/yyyy')
DS = datestr([DT + zeros(size(DT,1),1)], 'mm/dd/yyyy HH:MM:SS')

producing:

DS =
  2×19 char array
    '08/21/2020 00:00:00'
    '09/21/2020 00:00:00'

or alternatively just.

    DS = datestr(DT, 'mm/dd/yyyy HH:MM:SS')

producing the same result.

If you want to change how it is displayed, change the Format property.

>> dt = datetime('now')
dt = 
  datetime
   23-Aug-2020 15:43:06
>> dt.Format = 'dd-MMM-yyyy'
dt = 
  datetime
   23-Aug-2020

If you want to change what's stored and used for calculation, dateshift the datetime to the start of the day.

>> dt2 = dateshift(dt, 'start', 'day');
>> dt - dt2
ans = 
  duration
   15:43:06