Charlotte Foust
cfoust at infostatsystems.com
Wed Apr 9 10:21:31 CDT 2003
You should have a surcharge, not a discount! It's all your fault that
US developers have to deal with internationalization issues in their
application! <VBG>
Charlotte Foust
-----Original Message-----
From: Software Design & Solutions Pty Ltd.
[mailto:SDSSoftware at Optusnet.com.au]
Sent: Wednesday, April 09, 2003 4:36 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Dates again- aarrgghh
I am amazed that that 'feature' hasn't bitten me before.
Shouldn't we non US developers get a discount? (grin)
----- Original Message -----
From: Stuart McLachlan <mailto:stuart at lexacorp.com.pg>
To: Software Design & Solutions Pty Ltd.
<mailto:SDSSoftware at optusnet.com.au> ; accessd at databaseadvisors.com
Sent: Wednesday, April 09, 2003 9:40 PM
Subject: Re: [AccessD] Dates again- aarrgghh
It's a "feature" of Access. From the A2K Help file:
"Use International Date Formats in SQL Statements
You must use English (United States) date formats in SQL
statements in Visual Basic.
However, you can use international date formats in the
query designgrid."
On 9 Apr 2003 at 20:03, Software Design & Solutions P
wrote:
> 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
>
>
--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software
Development,System Support.
_______________________________________________
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/86ed342b/attachment-0001.html>