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

Question

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:

user_19211199 · Answer

I was able to get it to work by using:

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

user_5632629 · Answer

use:

=QUERY(A2:B, "select A where B < date '"&TEXT(G2, "e-m-d")&"'", )