Extracting index of specified date from datetime array

83 views (last 30 days)
Let us say that I have a datetime array which has dates that goes like these:
'2015-05-03 23:59:56'
'2015-05-03 23:59:56'
'2015-05-03 23:59:56'
'2015-05-03 23:59:56'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
Now, I would like to know the indices of one certain element, say {'2015-05-03 23:59:57'}. How can I get that?
I tried with example given in https://in.mathworks.com/help/finance/datefind.html, but even for the example given there is not getting executed in my pc. It is giving an error ‘Undefined function 'datefind' for input arguments of type 'double'.’. I suspect that it may be due to not having the proper toolbox. The toolbox that I am having are:
Curve Fitting Toolbox, Parallel Computing Toolbox, Partial Differential Equation Toolbox, Signal Processing Toolbox and Symbolic Math Toolbox
Thanks in advance.

Accepted Answer

Walter Roberson
Walter Roberson on 12 May 2021
S = datetime({'2015-05-03 23:59:56'
'2015-05-03 23:59:56'
'2015-05-03 23:59:56'
'2015-05-03 23:59:56'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'
'2015-05-03 23:59:57'})
S = 12×1 datetime array
03-May-2015 23:59:56 03-May-2015 23:59:56 03-May-2015 23:59:56 03-May-2015 23:59:56 03-May-2015 23:59:57 03-May-2015 23:59:57 03-May-2015 23:59:57 03-May-2015 23:59:57 03-May-2015 23:59:57 03-May-2015 23:59:57 03-May-2015 23:59:57 03-May-2015 23:59:57
probe = datetime('2015-05-03 23:59:57')
probe = datetime
03-May-2015 23:59:57
find(S == probe)
ans = 8×1
5 6 7 8 9 10 11 12
  3 Comments
Stephen23
Stephen23 on 22 Mar 2023
@matteo franchi: it is clear that the date/time values do not exactly match each other. So you first need to decide if you want to find:
  • the single pair of closest date/time values?
  • all date/time values that are within a particular range/tolerance?
  • some other criteria...
Walter Roberson
Walter Roberson on 22 Mar 2023
Remember that when you use == that everything down to nanoseconds (or further) must be identical.

Sign in to comment.

More Answers (0)

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Tags

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!