Medium Time setting does not hide date from a date/time duplicateq

Discussion in 'Microsoft Access Getting Started' started by Guest, Jun 26, 2005.

  1. Guest

    Guest Guest

    We just converted our 97 Access databases to Access 2003. The project went
    well with only some small code changes. One that has become larger over time
    is...
    we import XML files into the databases. In the 97 version, when the file
    was imported, the Date/Time datatype field only created a time. NO date.
    Which is what we wanted. Now with Acces 2003, every file imported since the
    conversion has both. Some of our duplicate queries need that field with only
    the time, and now with the date it gives us results we don't want.

    The files are imported by a windows service we had written. The service
    extracts the info from the XML and inserts it in to our databases.

    Even with the the date hidden by the "Medium Time" setting in Acces 2003,
    our queries still know a date is in the field and return false results!?

    My question:
    Does anyone know a way I can stript the date from the Date/Time datatype
    field in Access 2003 before, during or after a XML file is imported by a
    windows service?

    Can it be done in the windows service?
    Does it have to be done during the import to Access?
    Is there a delete query I can run that will strip only the date & not the
    time from that field??
    Or am I stuck with a change due to Microsoft software?

    1 developer has told me it is a Microsoft issue (no blame) but it can NOT be
    done at the windows service end? It happens when the files is created in
    Acces 2003??

    Any and all help is appreciated.

    Thank you in advance...
    TT
     
    Guest, Jun 26, 2005
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Micheal Palmer

    Changing Date/Time to conform to Zulu Date/Time

    Micheal Palmer, Jul 31, 2003, in forum: Microsoft Access Getting Started
    Replies:
    2
    Views:
    4,706
    Wayne Morgan
    Jul 31, 2003
  2. Aziz

    General/Medium Dates

    Aziz, Jan 28, 2004, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    146
    Van T. Dinh
    Jan 29, 2004
  3. Guest

    Medium Time setting does not hide date from a date/time duplicateq

    Guest, Jun 26, 2005, in forum: Microsoft Access Getting Started
    Replies:
    3
    Views:
    229
    Guest
    Jun 27, 2005
  4. Guest

    Medium Time setting does not hide date from a date/time duplicateq

    Guest, Jun 26, 2005, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    224
    Guest
    Jun 27, 2005
  5. Dj

    Setting Default Date/Time field to be blank or null

    Dj, Apr 14, 2008, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    217
    fredg
    Apr 15, 2008
Loading...

Share This Page