[AccessD]

This is not and never was a bug in Access, or Excel or any other program
that works with dates. It's is simply because the world has not settled on a
single date format, and computers cannot read minds.

So Access etc. has to make a best guess when someone manually enters a date
like "01//02/2001". Is it January or February????

The solution? Don't let users type dates. Use a calendar, either the
active-X one provided by MS, or a VBA only one that is implemented as an
Access form.

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of MastercafeCTV
> Sent:	Wednesday, December 08, 2004 6:25 PM
> To:	'Access Developers discussion and problem solving'
> 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