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