Hello !!! This topic is really helping me on creating a automated sheet ! i´m very beginner in codes.
The code: "SELECT C,D WHERE C >= date '2011-11-01' and C <= date '2011-11-30' ORDER BY C" has worked perfectly in my sheet when QUERY from *formresponse!* to *report!*. But, is there a way to keep "in" and "out" dates outside the formula? I will need and monthly output from the formresponse... In my case, connected do a cell value ? IF cell report!A2 had: 2011-11-01 and cell report!B2 had: 2011-11-30 my timestamp for reference is: formresponse!A I´m imputing the Query command at report!A4 I´ve tried someting like: =query(formresponse!A1:I, "SELECT F,G,H WHERE A >= report!A2 and A <= report!B2") And also like: =query(formresponse!A1:I, "SELECT F,G,H WHERE A >= report!$A$2 and A <= report!$B$3") ___ In my research i found something about ScalarFuntion https://developers.google.com/chart/interactive/docs/querylanguage?csw=1#scalar-functions If i could try something like filtering QUERY data by month it would work as well. Home someone can bring me a light in to this, and that I could have been clear on my doubt. Tnks a lot Ian -- 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/9e02e34f-2fdb-4a65-b17e-a2b8bf8aef51%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
