Cannot use find() inorder to find the index of a time in datetime array

18 views (last 30 days)
Hello,
I was trying to find the index of a particular time having datetime format (attached here as time.mat). I tried the usual find() inorder to find the index of an element but am constantly getting a 0×1 empty double column vector.
For example, I tried the following.
t=load('time.mat');
time=t.a; % a: [101×1 datetime]
index = find(time=='02-Dec-2014 07:05:25')
which gives me
0×1 empty double column vector.
Not sure why that is happening even though '02-Dec-2014 07:05:25' is present as the last element in the array.
Thank you for any help.

Accepted Answer

Matt J
Matt J on 11 Apr 2022
Edited: Matt J on 11 Apr 2022
Because you have sub-second precision in "t.a",
t=load('time.mat');
t.a(end)
ans = datetime
02-Dec-2014 07:05:25
seconds( t.a(end) - datetime('02-Dec-2014 07:05:25'))
ans = 0.6015
  5 Comments
Matt J
Matt J on 11 Apr 2022
t=load('time.mat');
tmin=min(t.a);
time=seconds(t.a-tmin);
N=numel(time);% a: [101×1 datetime]
index = interp1(time,1:N, seconds(datetime('02-Dec-2014 07:05:25')-tmin),'nearest')

Sign in to comment.

More Answers (0)

Categories

Find more on Matrices and Arrays 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!