MATLAB: Finding the end date of each month in the own sequence of dates

dates eomday eomdateMATLAB

Dear all,

I have the following sequence of dates ("mm/dd/yy" format).

dates = ['01/01/97'
       '01/23/97'
       '01/27/97'
       '01/31/97'
       '02/06/97'
       '02/07/97'
       '02/10/97'
       '02/21/97'
       '02/24/97'
       '02/27/97'
       '03/11/97'
       '03/27/97'
       '03/28/97'];

I would like to find the end date for each month ('01/31/97','02/27/97','03/28/97'). Please note, that the end date of each month does not correspond to the calender end date of each month. So, simply using the "eomday" or "eomdate" function won't work.

Thanks a lot!

Best Answer

dat=datevec(dates)
[~,idx]=unique(dat(:,1:2),'rows','last')
res=dates(idx)

Related Solutions

MATLAB: Finding the end date of each month/year

one way

dates =[ '23/11/08'
'28/12/08'
'25/01/09'
'22/02/09'
'29/03/09'
'26/04/09'
'24/05/09'
'28/06/09'
'26/07/09'];
dv = datevec(dates,'dd/mm/yy');
dc = num2cell(dv(:,1:2),1);
enddates = datestr(datenum(dc{:},eomday(dc{:})),'dd/mm/yy');

[Y, M] = datevec(dates,'dd/mm/yy');
out = datestr(datenum([Y, M, eomday(Y, M)]),'dd/mm/yy');

second way with use function eomdate from Financial Toolbox

enddates = datestr(eomdate(datenum(dates,'dd/mm/yy')),'dd/mm/yy');

other way

[Y, M] = datevec(dates,'dd/mm/yy');
enddates = datestr(datenum(Y,M+1,1)-1,'dd/mm/yy');

MATLAB: Calculate time intervals in an hour

% Create an input data table
startDateStr = {'2014-05-26 04:44:44';
                '2014-05-26 04:45:44';
                '2014-05-26 05:44:44';
                '2014-05-26 05:45:44';
                };
endDateStr   = {'2014-05-26 04:44:55';
                '2014-05-26 04:45:56';
                '2014-05-26 05:44:57';
                '2014-05-26 05:45:58';
                };
startTime = datetime(startDateStr,'InputFormat','yyyy-MM-dd hh:mm:ss');
endTime = datetime(endDateStr,'InputFormat','yyyy-MM-dd hh:mm:ss');
tbl = table(startTime,endTime);
% Find the unique hours, and the index to those hours
hourOfDay = dateshift(tbl.startTime,'start','hour');
[Hour,~,whichHour] = unique(hourOfDay);
% Find the durations (in seconds, but could be something else)
durationsInSeconds = seconds(tbl.endTime - tbl.startTime);
% Find the total duration for each of the unique hours
TotalDuration = accumarray(whichHour,durationsInSeconds);
% Put the result in a table
output = table(Hour,TotalDuration)

Best Answer

Related Solutions

MATLAB: Finding the end date of each month/year

MATLAB: Calculate time intervals in an hour

Related Question