Using cast on an Access Date/Time Field

I'm trying to do a 'Select' statement over and Access database that has
a field defined as Date/Time

I've tried      String query = "select cast(logdate as date) from
AuditTrail";
              ResultSet rs = stmt.executeQuery(query);

but I get a SQLSTATE 37000

detailMessage= "[Microsoft][ODBC Microsoft Access Driver] Syntax error
(missing operator) in query expression 'cast(logdate as date)'."


I can't figure out what I have wrong with this statement.  

Michael Smith
iSeries.mySeries.