How do I obtain the end of month dates for a time interval?

1 visualizzazione (ultimi 30 giorni)
if i have two dates that constitute a time interval such as : 726864 and 734169 is it possible to compute the end of month dates for the whole time interval?

Risposta accettata

Andrei Bobrov
Andrei Bobrov il 3 Lug 2011
d = [726864,734169]
dv = datevec(d(1):d(2));
d2 = unique(dv(:,1:2),'rows');
dm = eomday(d2(:,1), d2(:,2))

Più risposte (1)

the cyclist
the cyclist il 3 Lug 2011
I think the Financial Toolbox has functions that make things like this easier. Also, have you looked at the File Exchange?
Absent that toolbox, one way to do this would be to extract the year/month of your two dates using the datevec() command, which should make it easy to find all the interim months. Then make a vector with year-month-date of the first of each month, which is easier than finding the last date of each month (which can be 28,29,30, or 31!). Then, subtract a day to get the last datenum of the previous month.

Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by