Logical lookup between two dates

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.

[Ameer Hamza]

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]

What does "b<=>c" mean? What exactly is a "date vector"? Please provide some input data.

[Richard Turner]

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...

Answer 1

[Guillaume]

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

[Richard Turner]

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