I am using query and importrange function to collect data from another Google sheet, i have already filtered a column, but now i have to filter FROM the main sheet on a date column (ABOVE MAY 2022) in the Query function. this is my actual function that i have tried but it doesnt works. I would appreciate some help with this.
=QUERY(IMPORTRANGE("2WdjuvMkDmxjFT6IgQmXeQ8xn1fs5T-JkSVar86P7KdQ";"A:D");"Select Col1, Col3, Col4 Where Col3 contains 'Santa Cruz' and where Col1 = date '"&TEXT(A2,"yyyy-mm-dd")&"'")
CodePudding user response:
you are allowed to use where
only once:
=QUERY(IMPORTRANGE("2WdjuvMkDmxjFT6IgQmXeQ8xn1fs5T-JkSVar86P7KdQ"; "A:D");
"select Col1,Col3,Col4
where Col3 contains 'Santa Cruz'
and Col1 = date '"&TEXT(A2,"yyyy-mm-dd")&"'")