Intersection(A,B) not working for date

2 views (last 30 days)
Meh
Meh on 2 Jun 2015
Edited: Guillaume on 2 Jun 2015
I have A and B date vectors. I want to extract the common dates from both. I used:
[C,ia, ib]=intersection(A,B)
But it is giving me extremely few results than expected. Any solution?

Accepted Answer

Ingrid
Ingrid on 2 Jun 2015
you should use a round before using using intersection to avoid floats not being equal to each other. If the dates are distinguishably by day (i.e. no hours given) you could use this
[C,ia, ib]=intersection(round(A),round(B))
  1 Comment
Guillaume
Guillaume on 2 Jun 2015
Edited: Guillaume on 2 Jun 2015
This answer would be more or less correct if the OP was using date numbers. But for accuracy down to the second, I would actually multiply the date numbers by 24x3600 before rounding.
As the OP is using date vectors though, Star's answer is the correct one.

Sign in to comment.

More Answers (1)

Star Strider
Star Strider on 2 Jun 2015
Since date vectors are row vectors, use the 'rows' option with intersect:
[C,ia, ib]=intersect(A,B,'rows');

Community Treasure Hunt

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

Start Hunting!