Software Design & Solutions Pty Ltd.
SDSSoftware at Optusnet.com.au
Tue Apr 8 23:26:38 CDT 2003
strsql = "INSERT INTO tblItemsInQuote (quoteID, ItemDate, Sequence) VALUES (" & IntQuoteID & ",#" & Format(DteDay1, "dd-mm-yy") & "#," & StrDayNo & ")"
This string works, but I end up with a date formatted mm-dd-yy in my table.
The field in the table has a format property of dd-mm-yy.
????
Kath Pelletti
Software Design & Solutions Pty Ltd.
Ph: 9505-6714
Fax: 9505-6430
SDSSoftware at Optusnet.com.au
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030409/5fe020bd/attachment.html>