Google Sheets: Query where date>now() returns nothing

Question

I am using Google Sheets query function to bring data from a different sheet. This query works perfectly, matching two text fields (Where A='"&A5&"')

=query('Modifications'!$A$3:$I,"Select E,F,G,H,I Where A='"&A5&"'order by E desc limit 1")

However, when I try to add an AND statement as part of the Where clause to filter by today's date ( now() ), the query returns nothing:

=query('Modifications'!$A$3:$I,"Select E,F,G,H,I Where A='"&A5&"' AND F>now() order by E desc limit 1")

What am I missing?

score 1 · Accepted Answer · answered Apr 23 '19 at 16:25

1

try like this:

=QUERY('Modifications'!$A$3:$I, 
 "select E,F,G,H,I 
  where A = '"&A5&"' 
    and F > date '"&TEXT(TODAY(), "yyyy-mm-dd")&"' 
  order by E desc 
  limit 1", 0)

answered Apr 23 '19 at 16:25

player0

124,011
12
67
124

Didn't work. Probably because my dates are in the following format: 1/30/2019. – quelquecosa Apr 23 '19 at 17:47
do you have a valid dates in F column? - https://www.benlcollins.com/spreadsheets/query-dates/ – player0 Apr 23 '19 at 18:00
1

You got it my friend. I was using Sept 31, 2019, a date that does not exist. Thank you. – quelquecosa Apr 23 '19 at 18:13

Google Sheets: Query where date>now() returns nothing

1 Answers1

Linked