This question already has an answer here:
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.