[AccessD]

Try and customize the settings of languages, numbers, times and dates.
You probably have your machine set to a US English format....
On WinXP go Control Panel => Regional and Language Options.
This should clear up the problem you are describing.

Always use US date format when you are using a Date as a selection
criterium, etc. in SQL action queries.

Hope this helps
Borge

----- Original Message ----- 
From: "MastercafeCTV" <mastercafe at ctv.es>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Thursday, December 09, 2004 9:25 AM
Subject: [AccessD]


>
> Hi group, this week we are looking for DATE problems and solutions over
this
> bug from Access.
>
> We use normally dd/mm/yyyy to capture de date information, and configure
the
> windows DATE/TIME to this format, when yo try to input some date you can
see
> this diferences:
>
> Input Format  Format dd/mmm/yy
> 01/02/2001 -  01 Feb 01
> 03/02/2001 -  02 Mar 01
> 13/02/2001 -  13 Feb 01
> 03/04/2001 -  03 Apr 01
>
> Its totally stupid the translation, we saw that use the main format as
they
> want. If you put a day over >12 then the format it's OK dd/mm/yyyy, but if
> you put a day under 13 depend of the month.. If the month if higher then
the
> format that the use is mm/dd/yyyy but not always, only for months lower
than
> 6.
>
> At this moment we only found a solution for this, convert all date to
string
> 8 positions (yyyymmdd) and then use this ISO format to make any SQL, but
the
> speed are not good on a large ammount of registry.
>
> Any ideas to control de DATE correctly?? We problem we saw in Access 2 and
> always use String format, but actually we hope that with Access XP and
WinXP
> could be solved.
>
> Thanks.
>
>
> Juan Menendez
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


---
Outgoing mail is certified Virus Free by AVG Anti Virus System.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 20/11/2004