Query formula returns only one row of data on Google Sheets when comparing dates-CodePudding

Home > Enterprise > Query formula returns only one row of data on Google Sheets when comparing dates

Query formula returns only one row of data on Google Sheets when comparing dates

Time：06-03

I'm trying to get a Query formula to filter rows that have a past date in column B. Here's the formula:

=QUERY(users!A2:BB,"SELECT B, C, D, G, AI WHERE AM < "&DEVS!A2&"",1)

AM contains the row's date, and DEVS!A2 contains Today's date using the TODAY() formula.

I get one result in the row I have the Query on, but it doesn't automatically reutrn the other results.

The scenario is recreated in this sample sheet: