I'm trying to create two cells that will update my query: A >= dateA1 and A <= date B1.My goal is to create a search page for the data, where the end user could insert a date or the =today() function and it would update the query. I am currently getting a formula parse error from:=QUERY(Data!6:1397,SELECT A,B,C,D,E,F,G,H,I,J,K,L WHERE A >= dateA1and A <= dateB1)
Dynamic date range query
google spreadsheets;google spreadsheets query