query one sheet based on cell in another sheet

Question

My master data sheet is named MASTER. In my sheet named PRINT I want to be able to use a date picker, or somehow be prompted for a date, and then a Query pulls data from Master where date selected matches dates in MASTER column B. I have tried the following Query statement but it will only work if I change both sheets Date columns to TEXT format. I need to keep my date formats as is. If all that makes sense, I would really appreciate some help. My end goal is I just want a huge list of fabrication jobs, listed by date, to be queried and pulled to another sheet for printing. Leaving all Master data in tact and where the PRINT sheet can simply have a date change done by any user and get the list they need.

=Query(MASTER!A:P,ʺselect * where B ='ʺ&A2&ʺ'ʺ,0)

The above Query is on my TEST sheet where I have a date picker in column A2

Here is shared sheet - Note that the date format I am using on MASTER is what I need and it doesn't seem to impact the other query being done on the CAPACITIES sheet. docs.google.com/spreadsheets/d/… — John

JPV JPV · Accepted Answer · 2014-12-02T20:25:14

Try:

=Query(MASTER!A:P,"select * where B =date"""&text(A2, "yyyy-mm-dd")&""" ",0)

and see if that works for you ?

query one sheet based on cell in another sheet

1 Answers