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:

score 0 · Answer 1 · answered Jun 02 '22 at 22:57

0

I was able to get it to work by using:

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

answered Jun 02 '22 at 22:57

Hypha

score 0 · Answer 2 · answered Jun 02 '22 at 22:58

0

use:

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

answered Jun 02 '22 at 22:58

player0

2 Answers2