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
> [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 post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
