Find indices of matching date times

76 visualizzazioni (ultimi 30 giorni)
Hi,
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?
  2 Commenti
Rik
Rik il 4 Giu 2021
Have you tried ismember? It will probably be close to what you need.
Akira Agata
Akira Agata il 4 Giu 2021
Or have you tried withtol function?

Accedi per commentare.

Risposta accettata

Chidvi Modala
Chidvi Modala il 7 Giu 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)

Più risposte (0)

Categorie

Scopri di più su Data Type Conversion in Help Center e File Exchange

Prodotti


Release

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by