Thank you very much~!
I find that it works too.
=QUERY('表單回應'!A:D,"select B,C,D WHERE B >= date """&text(B5,"yyyy-MM-dd")&"""
and B <= date """&text(D5,"yyyy-MM-dd")&""" order by B asc")2014-01-27 Sergey Grabkovsky <[email protected]>: > You can do this by specifying the range parameter in the URL, when you > request the spreadsheet. Here is an example URL for your spreadsheet that > requests the range B2:D2. I bolded the range parameter. > https://docs.google.com/spreadsheet/tq?key=0AsMhUCf4hZD6dEtuVlRydHZLQ3c4UWZLbzRYMUJiREE&; > *range=B2:D2*#gid=0 > > - Sergey > > > On Sat, Jan 25, 2014 at 12:44 AM, 訓育組 <[email protected]> wrote: > >> >> https://docs.google.com/a/lkes.mlc.edu.tw/spreadsheet/ccc?key=0AsMhUCf4hZD6dEtuVlRydHZLQ3c4UWZLbzRYMUJiREE#gid=2 >> I want the data between the date "B2 and D2" >> How to put the command "where" in the following QUERY ？ >> =QUERY('表單回應'!A:D,"select B,C,D order by B desc") >> PLEASE HELP ME, THANKS~! >> >> TheNez於 2011年12月1日星期四UTC+8下午2時52分39秒寫道： >>> >>> you can use the query language to obtain that. >>> >>> use the playground sample to test it: http://code.google.com/ >>> apis/ajax/playground/?type=visualization#using_the_query_language >>> >>> 1. change the spreadsheet link to yours >>> 2. in the setQuery function change the query to this: >>> query.setQuery("SELECT C,D WHERE C >= date '2011-11-01' and C <= date >>> '2011-11-30' ORDER BY C"); >>> where C is the date column and D is the data column. >>> pay attention to the 'date' type declaration in the query. >>> >>> for more details on the query language go to this link: >>> http://code.google.com/apis/chart/interactive/docs/querylanguage.html >>> >>> Good luck, >>> >>> >>> >>> >>> On Wed, Nov 30, 2011 at 11:07 PM, Derek <[email protected]>wrote: >>> >>>> I want to query a google spreadsheet to select some columns dependant >>>> on 1 date. For example, I want all records for orders shipped in the >>>> month of November. The ship date cell uses mm/dd/yyyy. How do I >>>> write that I want all records for orders shipped between 11/1/2011 and >>>> 11/30/2011? >>>> >>>> Thanks, >>>> Derek >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Google Visualization API" group. >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to google-visualization-api+ >>>> [email protected]. >>>> For more options, visit this group at http://groups.google.com/ >>>> group/google-visualization-api?hl=en. >>>> >>>> >>> -- >> 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 >> http://groups.google.com/group/google-visualization-api. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "Google Visualization API" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/google-visualization-api/KuDj3rJ762k/unsubscribe > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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 http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
