How would you query for todays date only? Thanks you,
Rob On Thursday, December 1, 2011 12:52:39 AM UTC-6, TheNez wrote: > > 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 view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/50vMllckV0YJ. 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.
