QUERY Data from IMPORTRANGE not populating data

[Jay Bryant]

I am trying to import data from another sheet based on the date in B1. In the source sheet, column 4 is the date column and column 2 is the data I need to import. Here is the formula I'm using. I get the header for column 2, but no data is populating.

=QUERY({IMPORTRANGE("https://myURL","Project Entry Response!a:f")}," select Col2 where Col4 ='"&B1&"'")

[Rani Urbis]

Try this: 

=QUERY(IMPORTRANGE("https://myURL","Project Entry Response!A:F"), "SELECT Col2 WHERE Col4 = DATE '"&TEXT(B1, "yyyy-mm-dd")&"'")