[AccessD] Most common problems/situations

Bill Benson bensonforums at gmail.com
Thu Aug 21 09:35:31 CDT 2014


I have always worked in US so I don't think I have ever run into this. But,
if there is SQL looking for 08/04/2014 and in the data there is no
08/04/2014, but there happens to be a 04/08/2014, and the user's local date
format is Europe, will a match on  04/08/2014 be returned? What would the
workaround be if your US database BE has an Access FE being used in
European environment?
On Aug 21, 2014 9:29 AM, "Gustav Brock" <gustav at cactus.dk> wrote:

> Hi Jack
>
> There is no "sometimes". In the GUI, the date format is always localized
> except if you specify another format in the Format property.
> In VBA and SQL, date string expressions are always read in US, then local,
> then ISO format until a match.
> For CDate and DateValue, however, the sequence is local, US, ISO.
> For ADO and FindFirst, only the ISO format is reliable.
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] På vegne af jack drawbridge
> Sendt: 21. august 2014 14:30
> Til: Access Developers discussion and problem solving
> Emne: Re: [AccessD] Most common problems/situations
>
> Arthur,
>
> Thought I'd pass this on since it came by today and seems to fit your
> request.
>
> " In the user interface - forms, query criteria, - where users enter
> dates, MS assumes the format is the system setting, even if the date is
> enclosed in # tags, as it might be in query criteria. I have always been
> led to believe that any date between # marks had to be MDY (regardless of
> system setting), but no. Only sometimes.
>
> You'd think MS could enable users to set the date format that Access uses
> everywhere, including SQL and VBA, regardless of the system date format
> setting.
>
> I wonder how many non-USA users have been caught by this, without
> realizing it? "
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list