Hello. I'm trying to get a list of rows from a spreadsheet. I want to
filter my results using a date column. In the GUI the dates where
added like "2009-10-01" and google shows them like "10/1/2009". I want
this column to be used as a date (so I can query like "mydatecolumn <
now()" or similar. But everytime I try to do something like that I'm
getting an http 500 error code (I'm using php with Zend GData). Here's
my code:

// get rows for this spreadsheet
$query = new Zend_Gdata_Spreadsheets_ListQuery();
$query->setSpreadsheetKey($spreadsheet_key);
$query->setWorksheetId($worksheet_id);

$query->setSpreadsheetQuery('fecha = "10/1/2009"');  // THIS WORKS
# $query->setSpreadsheetQuery('fecha = date "2009-10-01" ');  // THIS
DOES NOT WORK

$rows = $gdClient->getListFeed($query);

if (count($rows->entry) == 0) {
        echo "No Data Found\n";
} else {
        foreach ($rows as $row) {
                $rowData = $row->getCustom();
                foreach($rowData as $customEntry) {
                        echo '      ' . $customEntry->getColumnName() . ': "' .
$customEntry->getText() . '"' . "\t";
                }
                echo "\n";
        }
};

Is it possible to work with date data type using the data api for
spreasheet?

Thanks,
Jose.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Google Docs Data APIs" group.
To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com
To unsubscribe from this group, send email to 
google-docs-data-apis+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to