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.