Find datetime in a vector

98 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)

Community Treasure Hunt

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

Start Hunting!