[AccessD] Dates again- aarrgghh

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. 



More information about the AccessD mailing list