Select data from a date range

2 次查看（过去 30 天）
Harry Lindner
Harry Lindner 2015-6-15
编辑： Harry Lindner 2015-6-15
I would like to select data from a date range using month end. I have a bunch of month end dates in datetime and numeric values for each of those. I want to be able to extract the values by inputting a date range. For example, return all numeric values for 1/31/2012 to 12/31/15. Then I would take the standard deviation of that 3 year history.

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

回答（1 个）

Azzi Abdelmalek
Azzi Abdelmalek 2015-6-15
d=datenum('1/31/2010'):datenum('12/31/15') % Example
data=randi(9,numel(d),1)'
d1=datenum('1/31/2012')
d2=datenum('12/31/2015')
idx=d>d1& d<d2
out=[d(idx); data(idx)]'
  1 个评论
Harry Lindner
Harry Lindner 2015-6-15
编辑：Harry Lindner 2015-6-15
Hi, Thank you for the reply. I only have month end values, so this index exceeds the matrix dimensions.
I attached a sample file to the original question.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by