CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Draco D
Draco D

Reputation: 334

Filtering on google sheets using Query returns just one row

Context

I am trying to filter data by date range using Query. I want data from 31/12/2019 onwards. This is the formula I used:

=Query(Query(ImportRange("ID", "RotorkPrice"),"offset 2",1),"select * where Col1 >= '2019-12-31'")

This only returns the top row (though I did ask Query to remove the first 2 rows). The data looks like so:

enter image description here

I took examples from here and here, and have been following this guide.

Problem

Is there a way to only draw data from this date onwards using Query?

The spreadsheet is here.

Upvotes: 2

Views: 693

Answers (1)

player0
player0

Reputation: 1

you are missing date. try:

=QUERT(QUERY(IMPORTRANGE("ID", "RotorkPrice"), 
 "offset 1", 0), 
 "where Col1 >= date '2019-12-31'", 0)

Upvotes: 1

Related Questions