Using QUERY and IMPORTRANGE to pull records from a specific date range [duplicate]

Question

I have created two spreadsheets.

This one is my source data: https://docs.google.com/spreadsheet_A

And I would like this one to just be the people who are currently here (so Column D < today and Column E > today): https://docs.google.com/spreadsheets_B

I keep tinkering with the formula for the date, but can't get it right. Most recent error I've gotten is

Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: A.

Any thoughts?

Answer 1

use Col1,Col2,Col3,Col4 instead of A,B,C,D when you QUERY the IMPORTRANGE

=QUERY(IMPORTRANGE("16ATkORZt0_vEUdyKMk1trWymhfJ5-aJPlMdRT0-yM9Q", "A1:E"), 
 "select Col1,Col2,Col3,Col4 where Col4 >= '"&TEXT(DATE(2018,1,2),"yyyy-MM-dd")&"'", 1)

=QUERY(IMPORTRANGE("16ATkORZt0_vEUdyKMk1trWymhfJ5-aJPlMdRT0-yM9Q", "A2:D"),
 "select Col4 where Col4 >= '"&TEXT(DATE(2019,1,2),"yyyy-MM-dd")&"'")

=QUERY(IMPORTRANGE("16ATkORZt0_vEUdyKMk1trWymhfJ5-aJPlMdRT0-yM9Q", "A1:E"), 
"select Col1, Col2, Col3, Col4, Col5 where Col5 <= '" &TEXT(E2, "yyyy-MM-dd")& 
                                    "' AND Col4 >= '" &TEXT(D2, "yyyy-MM-dd")& "'")

UPDATE - final solution:

=QUERY(IMPORTRANGE("16ATkORZt0_vEUdyKMk1trWymhfJ5-aJPlMdRT0-yM9Q", "A1:E"), 
 "select Col1,Col2,Col3,Col4 where Col5 >= '"&TEXT(DATE(2019,1,2),"yyyy-MM-dd")&"'
                               and Col4 <  '"&TEXT(DATE(2019,1,2),"yyyy-MM-dd")&"'", 1)

Answer 2

Resolved by @user0 with:

=QUERY(IMPORTRANGE("16ATkORZt0_vEUdyKMk1trWymhfJ5-aJPlMdRT0-yM9Q", "A1:E"), 
 "select Col1,Col2,Col3 where Col5 >= '"&TEXT(DATE(2019,1,2),"yyyy-MM-dd")&"'
                               and Col4 <  '"&TEXT(DATE(2019,1,2),"yyyy-MM-dd")&"'", 1)