Usually with Access you need to have # around your dates. hth Laurie btw - the space in the column name - DON'T DO IT!!! (if you can help it - it just makes life difficult!) -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Loren Stafford Sent: Friday, July 06, 2001 3:08 PM To: zope@zope.org Subject: [Zope] ZSQL select on date/time Does anyone have a working example of how to select on a date/time column in an MSAccess database. Something like Arguments: FromDate:date select * from "Applicant Database" where [Date Received] > <dtml-sqlvar FromDate type=float> ...except the above syntax produces: Error type: sql.error Error value: ('07001', -3010, '[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.') ...regardless of value of type. -- Thanks -- Loren _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )