<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>I am amazed that that 'feature'
hasn't bitten me before. Shouldn't we non US developers get a discount?
(grin)</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=stuart@lexacorp.com.pg href="mailto:stuart@lexacorp.com.pg">Stuart
McLachlan</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=SDSSoftware@optusnet.com.au
href="mailto:SDSSoftware@optusnet.com.au">Software Design & Solutions Pty
Ltd.</A> ; <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, April 09, 2003 9:40
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Dates again-
aarrgghh</DIV>
<DIV><BR></DIV>It's a "feature" of Access. From the A2K Help
file:<BR><BR>"Use International Date Formats in SQL Statements<BR><BR>You must
use English (United States) date formats in SQL statements in Visual Basic.
<BR>However, you can use international date formats in the query
designgrid."<BR><BR><BR><BR>On 9 Apr 2003 at 20:03, Software Design &
Solutions P wrote:<BR><BR>> MessageThat's so strange. So it's an SQL
setting? <BR>> Thanks Andy / Gustav - advice taken.<BR>> <BR>>
Kath<BR>> ----- Original Message ----- <BR>>
From: Andy Lacey <BR>> To: <A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
<BR>> Sent: Wednesday, April 09, 2003 5:26
PM<BR>> Subject: RE: [AccessD] Dates again- aarrgghh<BR>>
<BR>> <BR>> Kath<BR>> IIRC SQL always uses US
format dates. If you change your format to<BR>> "mm-dd-yy"
it'll work. SQL will place the date in the table<BR>>
correctly, then your field's format will take over and display
it<BR>> correctly.<BR>> <BR>> Andy
Lacey<BR>> <A
href="http://www.minstersystems.co.uk">http://www.minstersystems.co.uk</A><BR>>
<BR>> <BR>> <BR>> -----Original
Message-----<BR>> From: <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A><BR>>
[mailto:accessd-bounces@databaseadvisors.com] On Behalf
Of<BR>> Software Design & Solutions Pty Ltd.
Sent: 09 April 2003 05:27 To:<BR>> <A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A>
Subject: [AccessD] Dates again-<BR>>
aarrgghh<BR>> <BR>> <BR>> strsql = "INSERT
INTO tblItemsInQuote (quoteID, ItemDate,<BR>>
Sequence) VALUES (" & IntQuoteID & ",#" &
Format(DteDay1,<BR>> "dd-mm-yy") & "#," &
StrDayNo & ")"<BR>> <BR>> This string works,
but I end up with a date formatted mm-dd-yy in<BR>>
my table. <BR>> <BR>> The field in the table has
a format property of dd-mm-yy.<BR>> <BR>>
????<BR>> <BR>> Kath
Pelletti<BR>> Software Design & Solutions Pty
Ltd.<BR>> Ph:
9505-6714<BR>> Fax:
9505-6430<BR>> <A
href="mailto:SDSSoftware@Optusnet.com.au">SDSSoftware@Optusnet.com.au</A><BR>>
<BR>> <BR>>
----------------------------------------------------------------------<BR>>
--------<BR>> <BR>> <BR>>
_______________________________________________<BR>> AccessD
mailing list<BR>> <A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR>>
<A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>>
Website: <A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR>>
<BR>> <BR><BR><BR>-- <BR>Lexacorp Ltd<BR><A
href="http://www.lexacorp.com.pg">http://www.lexacorp.com.pg</A><BR>Information
Technology Consultancy, Software Development,System
Support.<BR><BR><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BODY></HTML>