Thanks for your help- I realized that if I put this in the form input statement null="" then it all worked out. -----Original Message----- From: McDonnell, Larry [mailto:lmcdonnell@protonenergy.com] Sent: Monday, June 02, 2003 7:06 AM To: Kelley, Sean; 'zope@zope.org' Subject: RE: [Zope] setting null date in SQL Hi, I can do this to an MS Access DB: <dtml-if mea_creation_date><dtml-if "mea_creation_date==''">NULL<dtml-else> <dtml-sqlvar mea_creation_date type=string></dtml-if><dtml-else>NULL</dtml-if> -----Original Message----- From: Kelley, Sean [mailto:SKelley@ci.santa-rosa.ca.us] Sent: Friday, May 30, 2003 5:06 PM To: 'zope@zope.org' Subject: [Zope] setting null date in SQL I cannot seem to set date to NULL in MS SQL with INSERT but it seems to work on UPDATE with this code: Insert sets date to 1/1/1900 <dtml-if "AppDelDate==''"> AppDelDate=NULL, <dtml-else> '<dtml-var name="AppDelDate" sql_quote>', </dtml-if> Trying this request to the group again since I have not found a solution. Sean _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )