[AccessD] Dates again- aarrgghh

It's bitten me many times :-(

When I need to build an SQL string using the value from a text box etc, I  always use 
something like:

strSQLstring = "  ...... fldDate = Datevalue('" & txtDate & "') ...."

That works regardless of regional settings.


On 9 Apr 2003 at 22:35, Software Design & Solutions P wrote:

> 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 
>   To: Software Design & Solutions Pty Ltd. ;
>   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."
> 

-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.