Query Importrange in Google Sheets-CodePudding

Data Set 1

Date - City - Amount
01-06-2022 - Bangalore - 10
25-06-2022 - Chennai - 20
02-07-2022 - Bangalore - 10

I am using "=query(IMPORTRANGE("URL","FY 22 - 23!A:I"),"select Col1,Col2,Col3 where Col2='Bangalore' and Col1>=01-07-2022")"

But it's giving me an error. Can someone help

CodePudding user response：

Try below query-

=query(IMPORTRANGE("URL","FY 22 - 23!A:I"),"select Col1,Col2,Col3 where Col2='Bangalore' and Col1>= date '" & Text(Date(2022,7,1),"yyyy-mm-dd") & "'")

CodePudding user response：

={query(IMPORTRANGE("URL","FY 22 - 23!A:I"),"select Col1,Col2,Col3 where Col2 = 'Bangalore' and Col1>= Date '"&text("01-07-2022","YYYY-MM-DD")&"' ")}