Logical lookup between two dates

2018 5 24
1 个回答
回答已采纳
更新时间：2018 5 25
9 次查看（30 天）

0 个投票

I am trying to create a logical lookup between 3 date vectors. Vector a is the lookup value (a date), Vector b is a start date, c is an end date. a is a larger size than b and c, which are both the same size.
I want to return a logical response (1) when a is b<=>c.
The vector size seems to be the main problem when trying to write this. I know there is a simple way to do it, but cant find the answer.

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Ameer Hamza
Ameer Hamza 2018-5-24
Can you share a sample of your code? Also since you mentioned that a is larger than b and c, so how do you want to deal with that?
Jan
Jan 2018-5-24
What does "b<=>c" mean? What exactly is a "date vector"? Please provide some input data.
Richard Turner
Richard Turner 2018-5-24
a is a 282x1 matrix containing sequential dates. b is a 50x1 matrix containing start dates. c is a 50x1 matrix containing end dates. I want to find out how many times the values in 'a' occur between a start date and end date - represented by the same row # in 'b' and 'c'. I don't have any code to share, I've tried indexing b and c using a, but I cant get anything but errors. I'm sure there is an elegant way of doing this...

请先登录，再进行评论。

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

 采纳的回答

Guillaume
Guillaume 2018-5-24

0 个投票

Assuming R2016b or later:
sum(a >= b' & a <= c')
In earlier versions
sum(bsxfun(@ge, a, b') & bsxfun(@le, a, c'))
a, b, c must be date numbers

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Richard Turner
Richard Turner 2018-5-25
Thanks - I'm on 2015b so the second answer worked. You've saved several hours of going around in circles. Thanks!

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Calendar 的更多信息

产品

版本

R2015b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by