How to define sequence of dates between to dates on monthly time step?

Question

Hydro 2017-12-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/372782-how-to-define-sequence-of-dates-between-to-dates-on-monthly-time-step

回答： Peter Perkins 2017-12-19

Hello, I want to generate sequence of dates between two dates on monthly time step, however, couldnt figure a way out. I have tried various options such as datenum, datestr, datetime etc but could not solve my problem. Here is a sample of one trial.

StartDate= datetime(1981,01,01);
EndDate=datetime(2010,12,31);
formatOut='yyyy-mm';
Date=StartDate:EndDate;
Date=datetime(Date,formatOut);

I know it won't work as the number of the argument are wrong. but I want the date in the following format. Any help would be highly appreciated.

Jan-1981
Feb-1981
Mar-1981
-------
--------
Dec- 2010

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Peter Perkins 2017-12-19

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/372782-how-to-define-sequence-of-dates-between-to-dates-on-monthly-time-step#answer_296859

在 MATLAB Online 中打开

Hydro, I think all you need is to add a step size of one calendar month (in your code you are stepping by one day):

StartDate = datetime(1981,01,01);
EndDate = datetime(2010,12,31);
Date = StartDate:calmonths(1):EndDate;
Date.Format = 'MMM-yyyy'

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

James Knowles 2017-12-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/372782-how-to-define-sequence-of-dates-between-to-dates-on-monthly-time-step#answer_296695

Here's a similar function I wrote for a similar purpose. It should put you on the write track and allow you to manipulate it for your own purposes.

function[m,y] = month_year(idx2,idx3)

month = ["Jan", "Feb", "March", "April", "May", "June", "July","Aug", "Sept", "Oct", "Nov", "Dec"]; year = [1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012];

m = month(idx2); y = year(idx3);

end