Use something like this:
var today = new Date();
var todayString = today.getYear() + '-' + today.getMonth() + '-' + today.
getDay();
query.setQuery("SELECT C,D WHERE C = date '" + todayString + "' ORDER BY C")
;
On Thursday, June 28, 2012 10:08:18 AM UTC-4, Robert.G wrote:
>
> 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/-/r--ruykYVdwJ.
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.
