To compare a date, you have to use a date literal, which has the format date
'yyyy-MM-dd'. Your query should look like this:
var selectStatement = 'SELECT A, B, C WHERE A >= date "2014-01-09" ';
(assuming your original dates are in the format "M/d/yyyy")
On Monday, August 11, 2014 1:54:19 PM UTC-4, Steve Webster wrote:
>
> Here is a snippet screenshot of column A.
>
> Here are results *without* the WHERE clause to show available data:
>
>
>
> On Monday, August 11, 2014 1:38:42 PM UTC-4, Steve Webster wrote:
>>
>> Need some query.setQuery help when using "new" Google Sheets.
>>
>> var selectStatement = 'SELECT A, B, C WHERE A >= "1/9/2014" '; // "A" is
>> date column with format 1/1/2014
>> console.log("Select= "+selectStatement);
>> query.setQuery(selectStatement);
>>
>> Syntax is successful, but results are nothing.
>>
>>
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
