CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Aurelio Martín
Aurelio Martín

Reputation: 11

google sheets query date only brings one row result

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?

enter image description here

Upvotes: 1

Views: 1025

Answers (1)

player0
player0

Reputation: 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)

Upvotes: 1

Related Questions