MATLAB: Convert year into Matlab date format

date

How can I convert the year into the matlab date format if I have a big data set? I have a table:

Year Data

1999

2000

2001 …

Best Answer

If you have a numeric vector containing year numbers, you can convert a vector into a datetime array object as follow

myVector = 2000:2010
datetime(string(myVector), 'Format', 'yyyy')

Related Solutions

MATLAB: Vector of dates going back one rolling year

You can subtract one from the year field:

>> Vend = clock;
>> Nend = datenum(Vend);
>> Nbeg = datenum([Vend(1)-1,Vend(2:end)]);
>> Nall = Nbeg:Nend;
>> Vall = datevec(Nall);

You might also want to adjust Nbeg by one, depending on whether you want to include start on the same date as the period ends on.

EDIT this code gives just first of each month, over the past twelve months (regardless of the end month):

>> Vend = clock;
>> Nbeg = datenum([Vend(1)-1,1+Vend(2),1]);
>> Vbeg = datevec(Nbeg);
>> Nall = datenum(Vbeg(1),Vbeg(2)+(11:-1:0),1);
>> datestr(Nall)
ans =
01-Nov-2015
01-Oct-2015
01-Sep-2015
01-Aug-2015
01-Jul-2015
01-Jun-2015
01-May-2015
01-Apr-2015
01-Mar-2015
01-Feb-2015
01-Jan-2015
01-Dec-2014

MATLAB: How to filter data by date

Suppose your timetable data in the variable td

spring = td(timerange('2010-04-01', '2010-05-31'), :);  % spring time data
summer  = td(timerange('2010-06-01', '2010-08-31'), :);  % summer  time data
autumn   = td(timerange('2010-09-01', '2010-10-31'), :);  % autumn  time data
winter   = td(timerange('2010-12-01', '2011-02-28'), :);  % winter   time data

Best Answer

Related Solutions

MATLAB: Vector of dates going back one rolling year

MATLAB: How to filter data by date

Related Question