Re: Date/Time datatype affects date/time query
- From: "Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 26 Jun 2005 13:39:27 -0700
answered in .queries
How many times did you post this?
Jeff Boyce
<Access MVP>
"Tim T" <TimT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:254B16AB-3F3F-47C5-9E52-08C099C58E6A@xxxxxxxxxxxxxxxx
> 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
.
- References:
- Date/Time datatype affects date/time query
- From: Tim T
- Date/Time datatype affects date/time query
- Prev by Date: RE: Need syntax or code to exort data from Access table to Excel
- Next by Date: RE: How do I insert jpeg file into Microsoft Access database?
- Previous by thread: Re: Date/Time datatype affects date/time query
- Index(es):
Relevant Pages
|
