[Zope] Using ZSQL Method to call MS Acces DB using their date field

[McDonnell, Larry]

Hi,

I can use this sql call and find the records I am looking for:

SELECT none_ORDER_HIST_LINE.PART, none_ORDER_HIST_LINE.DESCRIPTION, 
none_ORDER_HIST_LINE.QTY_SHIPPED, none_ORDER_HIST_LINE.DATE_SHIPPED, 
none_ORDER_HIST_LINE.SHIP_VIA

FROM none_ORDER_HIST_LINE
WHERE (((none_ORDER_HIST_LINE.DATE_SHIPPED)=#6/29/01#));

What is the parameter setting for #6/29/01# in ZSQL so I can input the date
the wish to find? Thanks.


Larry McDonnell

Proton Energy Systems
50 Inwood Rd.
Rocky Hill, CT 06067
(860) 571-6533 ext. 531
Email:lmcdonnell@protonenergy.com
www.protonenergy.com