Software Design & Solutions Pty Ltd.
SDSSoftware at Optusnet.com.au
Wed Apr 9 05:03:16 CDT 2003
MessageThat's so strange. So it's an SQL setting?
Thanks Andy / Gustav - advice taken.
Kath
----- Original Message -----
From: Andy Lacey
To: accessd at databaseadvisors.com
Sent: Wednesday, April 09, 2003 5:26 PM
Subject: RE: [AccessD] Dates again- aarrgghh
Kath
IIRC SQL always uses US format dates. If you change your format to "mm-dd-yy" it'll work. SQL will place the date in the table correctly, then your field's format will take over and display it correctly.
Andy Lacey
http://www.minstersystems.co.uk
-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Software Design & Solutions Pty Ltd.
Sent: 09 April 2003 05:27
To: AccessD at databaseadvisors.com
Subject: [AccessD] Dates again- aarrgghh
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
------------------------------------------------------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030409/625c8e45/attachment-0001.html>