CODEWITHSUNDEEP
google-sheetsfiltergoogle-sheets-formulamatchgoogle-query-language
user5061526
user5061526

Reputation: 23

Google Sheets - Query date < doesn't work

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?

Upvotes: 1

Views: 187

Answers (1)

player0
player0

Reputation: 1

try:

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

Upvotes: 2

Related Questions