Re: changing dataformat from german to us-englisch

From: Andreas (anonymous_at_discussions.microsoft.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 02:21:08 -0800

Hi Jerry,

I’m sorry. But that is not what we do.

In our component is no line of code, that convert the date to a string.
There are only two methods we use:

ObjRS(“THISISADATE”) = Now
Copy the Date via Parameter form One Database (mdb) to another Database (mdb):
ObjCommand.Parameters(“THISISADATE”) = ObjRS(“THISISADATE”)

Nothing else. Do you have an other idea?

     
     ----- Jerry Pisk wrote: -----
     
     Don't parse the date as a string, pass it as a parameter of a command
     object. If you want to pass it as a string then you need to format it in the
     correct locale, not the one your users are running under.
     
     Jerry
     
     "Andreas" <abossong@z+remove+eb.de> wrote in message
     news:07573942-B777-4CB1-95E6-F064C2E2C189@microsoft.com...
> Hi,
>> we have a problem on some systems working with winnt4 sp6, mdac 2.5,
     access 2000 mdb, jet engine 4.0.
>> If our (vb6-)programm wants to save a date in the accass-database
     (datatype in db is date and in the programm it is also date) and it is a
     date between the first and the 12th of a month, the format is us-englisch
     instead of german (german format: dd.mm.yyyy; for example the 12th of
     january is 12.01.2004 in german, in the database it changes to 01-12-2004).
     If it is a date after the 12th, the format is saved in german (for example
     the 13th of january will be safed right as 13.01.2004).
> This problem comes on some pc, which are used with various software and
     not on a clean winnt4 installation. It semed to be that there are one or a
     few dll changed.
>> Which are they? What else could be the reason for changing the format of
     the date?
     
     
     

Relevant Pages

  • Re: Opening Excel from Access
    ... Tried changing it to an MDB but no luck. ... Dim MDBName As String, DefaultDirectory As String, SQLStg As String ... If MsgBox("Do you want to use this database in future?", ... comes when I click the button on Access form to show the Excel file. ...
    (comp.databases.ms-access)
  • Re: [PHP] Date/time format?
    ... Jason Pruim wrote: ... I am trying to figure out what format a string is in in a database. ... Below is an example of one of the lines in the database, What I'm really interested in is how it represents the "day". ... I have not been able to find ANY info about that format, other then other people using it in blogs. ...
    (php.general)
  • Re: Access 2007 user level security (lack thereof)
    ... the MDB database file format won't be obsolete for ... Only one virus can successfully infect an MDB file, ... "To obsolete is often used in technical fields ...
    (microsoft.public.access.security)
  • Re: Getting entries from an SQL database with datetime parameter
    ... format is what you want. ... funtion to convert date string into date time accordig to your needs. ... your database, you will run into troubles comparing date to string. ... > hard coded a query to populate the datagrid, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Manipulation of strings query
    ... I have received the data in an excel spreadsheet which contains the names in ... that I could enter it as 2 fields in a database and I'm certainly not doint ... The problem with the string input is that users will not be entering the ... > cintains names in the format LASTNAME, ...
    (microsoft.public.inetserver.asp.general)