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 >