=Query Returning A cells when B cells has current or future date

1
votes

I want to return text from cells in column A when column B contains current or future date.

Column B has set the data validation to date.

I'm able to make it work for today's date with this code, but I cannot do it for today's and future date. =QUERY(A9:B,"SELECT A WHERE B = date'"&TEXT(TODAY(),"yyyy-mm-dd")&"' ",0)

How could I do it?

1
google-sheets

1 Answers

1
votes

Insert:

 or B > date'"&TEXT(TODAY(),"yyyy-mm-dd")&"'

should work.