How to filter a table with a date field

Hi everyone

I have an n by m table called Table1 that needs to be filtered. I am new to Matlab so I am learning as I go. I need to return all the rows in Table1 when TRADE_DATE <= Feb 16 2024. How do I this? Thank you

    SYMBOL     TRADE_DATE     
    _______    ___________    

    {'SPX'}    03-Jun-2014                         
    {'SPX'}    09-Jun-2014                       
    {'SPX'}    10-Jun-2014                         

Answer 1

[Dyuman Joshi]

You can directly compare dates and use logical indexing to get the corresponding data -

%date to compare
dt = datetime(2014, 2, 16);

%Data
vec = table(rand(4,1), datetime(2014, 2, [11 13 17 19]).')

vec = 4×2 table
      Var1         Var2    
    ________    ___________

     0.33292    11-Feb-2014
     0.52272    13-Feb-2014
    0.095657    17-Feb-2014
     0.95912    19-Feb-2014

idx = vec{:,2}<=dt

idx = 4×1 logical array
   1
   1
   0
   0

out = vec(idx, :)

out = 2×2 table
     Var1         Var2    
    _______    ___________

    0.33292    11-Feb-2014
    0.52272    13-Feb-2014

[Manny]

it works as expected! thank you so much!!

[Dyuman Joshi]

You're welcome!