google sheets query date only brings one row result

Question

I have a tab call (Data Import) where I have the whole raw data imported in google sheets, in the next tab I have my query that looks as below;

This is the query -> =QUERY('Data Import'!$I1:$O, A1, 1)

A1 is equal to -> ="SELECT K, O, J WHERE J >= "&F1&""

F1 is equal to -> 44196

The result I get is only the first row, but I want all the rows that contains the same date which are a total 25 plus the header with the column names.

Does anyone figures what I am doing wrong?

Answer 1

try in A1:

=QUERY('Data Import'!I1:O, 
 "SELECT K,O,J WHERE J >= "&F1*1, 1)

you could also solve it like:

=QUERY('Data Import'!I1:O, 
 "SELECT K,O,J WHERE J >= date '"&TEXT(F1, "yyyy-mm-dd")&"'", 1)