Note that Gadfly does not support the DATE datatype. You can use VARCHAR to store a string, or switch to a different database, such as PostgreSQL (my personal preference) or MySQL. The answer to your question is found here: http://www.chordate.com/kwParsing/gadfly.html#table The main Gadfly pages are here: http://www.chordate.com/gadfly.html Troy -----Original Message----- From: Angietel [mailto:angietel@hotmail.com] Sent: Thursday, November 23, 2000 2:16 AM To: zope@zope.org Subject: [Zope] date in Z Gadfly Database When i create a table, one of the fields is consider as date type, but the Z Gadfly Database does not allow me to do that, it only accepts INTEGER instead of DATE type. The following is my SQL for creating a table:- CREATE TABLE customer (custid VARCHAR(10), custname VARCHAR(15), custactdate DATE, custadd1 VARCHAR(30), custadd2 VARCHAR(30)) Please let me know if i got an error.Thank You.