Gustav Brock
gustav at cactus.dk
Wed Apr 9 03:29:29 CDT 2003
Hi Kath Further to Andy's advice, you should force a slash as the separator and use four digit years too: Format(DteDay1, "mm\/dd\/yyyy") /gustav > 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.