Hi I'm trying to create a monthly query of data. I would like to return ALL MATCHES within a date range e.g. all dates in June even if there are multiple entries with the same date.
I'm trying two different approaches and failing at both. The "=QUERY" seems to be almost functional. I can return a list of dates by using =QUERY(Data!$A$2:$F$20,"select A",-1). However if the month changes my results are not limited to that specific month. So I'm trying to learn how to use the Google API functions "Select" and "Where" to specify the range of dates that the query must return. So if I have the following dates:- 06/29/2019 06/29/2019 06/30/2019 07/01/2019 07/01/2019 07/02/2019 THEN the query must return ALL MATCHES for June where June is requested *OR* ALL MATCHES for July where July is requested (and the same for all months in a year). Can anyone help with the syntax I need to improve this =QUERY( Data!$A$2:$F$20,"select A",-1) ? -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/a1d3a011-581b-4957-a019-f7286171e4be%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
