how to filter data by date?

hi everyone

I am trying to filter records by date. I am getting error. How do I fix it?

Code:

Data = convertvars(Data, 2, @(x) datetime(x, 'InputFormat', 'yyyy-MM-dd'));
FilteredDataRealizedVol = Data(:,["TRADE_DATE","REALIZED_VOLATILITY"]);
FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol(:,1) <= datetime(2016,7,18),:);
FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol(:,1) >= datetime(1928,1,27),:);

Error:

Error using  <= 
This operation is not defined between 'table' and 'datetime'. The input that is not a table or timetable must be a numeric or
logical array.

Error in LinearRegression (line 26)
FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol(:,1) <= datetime(2016,7,18),:);

Thank you

Answer 1

[Walter Roberson]

FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol{:,1} <= datetime(2016,7,18),:);

[Manny]

thanks for the reply. the errors are gone but the array was not filtered. it is still showing the unfiltered data. any idea on what is going on?

[Manny]

i updated the question. i added the second datatime date filter

[Dyuman Joshi]

Use curly brackets for accessing data inside the tables, as Walter has done as well.

Also, see - Access Data in Tables.

[Manny]

i did put the {} but still not working:

FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol{:,1} <= datetime(2016,7,18),:);
FilteredDataRealizedVol = FilteredDataRealizedVol(FilteredDataRealizedVol{:,1} >= datetime(1928,1,27),:);

[Manny]

i figured it out now.

the problem was in another part of the code that was referencing the unfiltered data.

thank you everyone for your help!

Answer 2

[Steven Lord]

Use a timerange to index into the timetable.