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
-~----------~----~----~----~------~----~------~--~---
