Find indices of matching date times

84 views (last 30 days)
I have 2 tables containing a column datetime. How can I find the first DateTime of table A in table B?
So if Table B contains 20 DateTimes. How can I find the index of the matching datetime from table A?

Sign in to comment.

Accepted Answer

Chidvi Modala
Chidvi Modala on 7 Jun 2021
You can refer to the following piece of code
s1 = {'2014-07-28' ; '2014-06-29' ; '2014-07-30'};
s2 = {'2014-08-01' ; '2014-07-30' ; '2014-07-9'};
t1 = datetime(s1,'InputFormat','yyyy-MM-dd')
t2 = datetime(s2,'Format','yyyy-MM-dd')
[logical_Index ,index] = ismember(t2,t1)

More Answers (0)




Community Treasure Hunt

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

Start Hunting!