<mock rant on><BR>Discount? DISCOUNT? ***!!$&*( You should pay a
premium cos SQl is predisposed to cater for you while we poor buggers have
to code around the damed thing all of the time.<BR><mock rant
off><BR><BR>But it's ok cos we've got used to it. Lembit even devised a
function to use to wrap around literal dates in this situation so that SQL
always handles them ok.<BR><BR>--<BR>Andy
Lacey<BR>http://www.minstersystems.co.uk<BR><BR><BR><BR>
<BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px;
MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">--------- Original Message --------<BR>From:
"Software Design & Solutions Pty Ltd."
<SDSSoftware@optusnet.com.au><BR>To: "accessd@databaseadvisors.com"
<accessd@databaseadvisors.com><BR>Subject: Re: [AccessD] Dates again-
aarrgghh<BR>Date: 09/04/03 12:39<BR><BR>
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
<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><BR><BR>
<HR>
<BR><FONT face="Courier New"
size=2>_______________________________________________<BR>AccessD mailing
list<BR><A class=autolink
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
class=autolink href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A class=autolink href="http://www.databaseadvisors.com/"
target=_blank>http://www.databaseadvisors.com</A><BR></FONT></DIV></BLOCKQUOTE>