Find datetime in a vector

108 views (last 30 days)
Tiago Dias
Tiago Dias on 16 Aug 2019
Commented: Tiago Dias on 16 Aug 2019
Hello,
I want to find the index of two times that belong on a colum with a bunch of timedates
t1 = datetime('10-09-2018 00:00:00','Format','dd-MM-uuuu HH:mm:ss')
t2 = datetime('28-09-2018 23:59:00','Format','dd-MM-uuuu HH:mm:ss')
idx_t1 = find(t_ref==t1)
idx_t2 = find(t_ref==t2)
idx_t1 should be 1020961 and idx_t2 1048320, but the results are empty
Thanks

Accepted Answer

KSSV
KSSV on 16 Aug 2019
Edited: KSSV on 16 Aug 2019
Use ismember
Or
idx = knnsearch(datenum(t_ref),datenum(t1)) ;
t_ref(idx)
t1
Or
dt = abs((datenum(t_ref)-datenum(t1))) ;
[val,idx] = min(dt) ;
t_ref(idx)
  4 Comments
Tiago Dias
Tiago Dias on 16 Aug 2019
oh ok, I though he would ignore the miliseconds due to the format I specified.
thanks

Sign in to comment.

More Answers (0)

Categories

Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by