I created a Google Form that employees complete, The data goes into the main sheet in a spreadsheet. I then want to split that data into separate sheets according to the date in one of the columns. In my separate sheets, I've entered the dates that I want included in cells A1 and B1. This is where I"m stuck.
Can someone look at this and tell me where I went wrong?
=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1gYzU1Tt-
0BNCZDBST06ETNHoE0pgkUdTpQctMqDW-1A/edit#gid=1240808529","'Form Responses 10'!A:JQ"),
"WHERE ET>=date """&text(A1,"yyyy-mm-dd")&""" and ET<=date """
&text(B1,yyyy-mm-dd")&""")