I am attempting to perform a query in Google Sheets, and one of the things I need to match is a date. I have seen other posts on this topic, but I am not having success. The advice that isn't working for me involves this phrase:
Here is the whole formula:
ARRAYFORMULA(IMPORTRANGE( "https://docs.google.com/spreadsheets/d/1Wyewpz0j_IiKK8ESOapX5L4AedjvHccLZOOKS2tZGUA/", "UsuallyAnotherSpreadsheetFile!B2:K")),"Select Col4, sum(Col8), sum(Col9) where (Col4=date '"&TEXT(A14,"yyyy-mm-dd")&"' AND (Col3='" & $F$1 & "') AND (Col1 = '" & ClientInfo!$H$1 & "') group by Col4")
I get the error: Unable to parse query string for Function QUERY parameter 2:
PARSE_ERROR: Encountered "group" at line 1, column 124. Was expecting one of: "and" ... "or" ... ")" ...
I will share my sheet here. Please see if you are able to get it to match the date based on what is in A14 on the sheet called