Plese check this link ; Query function with manipulation of dates<https://anandexcels.wordpress.com/tag/google-docs-spreadsheet/>
This work with new google spreadsheet. On Thursday, December 1, 2011 4:07:48 AM UTC+7, Derek 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 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/d/optout.
