Re: Strip out Excel timestamp

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks Douglas,

Noted and understood, it's only the date I need and I'll use your suggestion.

Cheers,
Ian.

"Douglas J. Steele" wrote:

> Don't do it!
>
> Don't separate Date and Time into two separate fields: you've got a
> timestamp, and it should be a single field.
>
> If you don't want the time, don't add it. If you want the time, use
> DateValue (or TimeValue) to extract only that component of the timestamp in
> which you're currently interested.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Ian" <Ian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:D4C4B672-E5D4-4346-97CC-EEB4D8B87D83@xxxxxxxxxxxxxxxx
> > Thanks for all the replies, its really helped. To answer the "Why"
> > question,
> > I'm running queries comparing Date in already constructed tables with the
> > DateTime field in the new table and the time component is giving me
> > spurrious
> > results in the query result. Second the Time component isn't actually
> > required, although if you know of a way to cleave the Time and write it to
> > a
> > new field I could "Have my cake and eat it".
> >
> > Thanks again
> > Ian.
> >
> > "Jeff Boyce" wrote:
> >
> >> Why?
> >>
> >> Are you trying to only see the date portion? If so, you can format the
> >> display, and keep the time data -- you don't have to toss it.
> >>
> >> Regards
> >>
> >> Jeff Boyce
> >> <Office/Access MVP>
> >>
> >> "Ian" <Ian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:C183D2F1-43C6-4369-98BE-909DC6B55DC8@xxxxxxxxxxxxxxxx
> >> >I have imported some data from an XL file into my Access db. One field
> >> >is a
> >> > date field that also contains a timestamp along with the date. I would
> >> > like
> >> > to strip out the timestamp just leaving the date as dd/mm/yyyy. Is
> >> > there
> >> > an
> >> > easy way to do this is Access or do I need to make the changes in the
> >> > XL
> >> > data
> >> > before importing into Access?
> >> >
> >> > Thanks
> >> > Ian.
> >>
> >>
> >>
>
>
>
.