[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 <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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030409/c81438e4/attachment-0001.html>