Google Sheets - Query date < doesn't work-CodePudding

Home > Enterprise > Google Sheets - Query date < doesn't work

Google Sheets - Query date < doesn't work

Time：09-17

I'm using google sheets, and I found that this doesn't work:

=QUERY(CSV!1:1000,"select J, AA, AD where J<date'2004-01-01'")

But this does:

=QUERY(CSV!1:1000,"select J, AA, AD where J>date'1900-01-01' and not J>date'2004-01-01'")

Can someone please explain why I have to make my query more complicated to filter by date?

CodePudding user response：

try:

=QUERY(CSV!1:1000, "select J,AA,AD where J < date'2004-01-01' and J is not null", )