[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