PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?VGltIFQ=?=
Guest
Posts: n/a
 
      26th Jun 2005
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format -medium date input mask-French Canadian =?Utf-8?B?QmlsbEQ=?= Microsoft Access Forms 5 15th Jul 2007 01:22 PM
Medium Time setting does not hide date from a date/time duplicateq =?Utf-8?B?VGltIFQ=?= Microsoft Access Getting Started 1 27th Jun 2005 09:34 PM
Medium Time setting does not hide date from a date/time duplicateq =?Utf-8?B?VGltIFQ=?= Microsoft Access Getting Started 3 27th Jun 2005 01:01 PM
Medium Time setting affects query with Date/Time datatype =?Utf-8?B?VGltIFQ=?= Microsoft Access VBA Modules 1 26th Jun 2005 09:57 PM
Converting medium time to short time James Microsoft Access VBA Modules 1 10th Feb 2004 04:47 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:41 PM.