"No Column" error in google sheets when using query function

user_18175054 0
Viewed 374

I am trying to query in order to ultimately, select between a date range to show only dates between YYYY-MM-DD and YYYY-MM-DD Current code i am trying to use:

=QUERY({"Master!A:J"}, "select * where Col1 >= date '2022-01-01' AND Col1 <= date '2022-01-31'")

I have also tried:

=QUERY({"Master!A:J"}, "select * where D >= date '2022-01-01' AND D <= date '2022-01-31'")

the data from the master sheet is being received by an apps script if that makes a difference?

test sheet: https://docs.google.com/spreadsheets/d/e/2PACX-1vTjTlorc1KKmMjgR3-N4agrLK3RFme2dmYwe7hF6fWotDtPbZJg71O1S0jJv0tIqwtIGTi_l61LSIE7/pubhtml

google-sheets
1 Answers

try:

=QUERY({Master!A:J}, 
 "where Col1 >= date '2022-01-01' 
    and Col1 <= date '2022-01-31'")

or:

=QUERY({Master!A:J}, 
 "where month(Col1)+1 = 1 
    and year(Col1) = 2022")
user_56326290
Related