Find the earliest common date and indicator of two date vectors.

Question

BdS 2019-5-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462606-find-the-earliest-common-date-and-indicator-of-two-date-vectors

评论： Rik 2019-5-17

采纳的回答： Guillaume

Hi,

I have got two date vectors: a=[28.02.2019;01.03.2019;04.03.2019;...] and b=[01.03.2019;04.03.2019;...]

How to find the earliest common date (=01.03.2019) and its vector index indicator (for date vector a is 2 and b is 1).

Thank you in advance for any suggestions.

2 个评论
显示无隐藏无

Guillaume 2019-5-17

在 MATLAB Online 中打开

"I have got two date vectors"

Please use valid matlab syntax for your examples.

In matlab a date vector is a 1x3 or 1x6 vector containing only 1 date.

a = [28.02.2019; 01.03.2019; 04.03.2019];

is not valid matlab syntax. So what do you have?

BdS 2019-5-17

Thank you for your code suggestion.

I have got a 55x1 datetime date vector which is vector A and a 56x1 datetime date vector which is vector B.

The date format is 06-Mar-2019

----

It does not have to be that the time vector A is always smaller than Vector B. It can change. It can also be that the first date of time vector A begins later than in date vector B. It must be flexible.

请先登录，再进行评论。

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

Answer 1

Guillaume 2019-5-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462606-find-the-earliest-common-date-and-indicator-of-two-date-vectors#answer_375462

在 MATLAB Online 中打开

intersect will give you all the dates common to a and b. By default, it also sorts them, so the first of these will be the earliest one, so:

[commondates, whereina, whereinb] = intersect(a, b);
firstcommon = commondates(1);
whereina = whereina(1);
whereinb = whereinb(1);

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

请先登录，再进行评论。

Answer 2

Rik 2019-5-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462606-find-the-earliest-common-date-and-indicator-of-two-date-vectors#answer_375435

编辑：Rik 2019-5-17

在 MATLAB Online 中打开

This answer assumes you have your dates in a datetime format. If you don't it should be relatively easy to convert to it. If your release is too old to support it, please comment with what release you're using.

a=datetime([2019 2019 2019],[2 3 3],[28 1 4]);
b=datetime([2019 2019 2019],[3 3 5],[1 4 1]);
[common_dates,ind_in_a]=ismember(a,b);
common_dates=a(common_dates);
[first,a_min_ind]=min(common_dates);
a_ind=find(ind_in_a==a_min_ind);
b_ind=find(b==first);