Re: Timestamps

Date/time fields are actually serial numbers formatted to display either
date, time or both. If you're storing the values with "general" format,
just change the format (in your form/query/report) to one of the available
time formats and use that to sort on. You will probably want to sort on
date+time to accommodate values over multiple 24hr periods.
-Ed


<scstrachan@xxxxxxxxx> wrote in message
news:1188560486.697528.150720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Does anyone know how to pull the date and the time from a timestamp
field in msaccess? Here is an example.

8/30/2007 11:53:00 AM

Ultimately, I would like to be able to place the date in one field and
the time in another. i would then like to be able to sort the time.
Any help would be appreciated.

Thanks,
Scott



.

Relevant Pages

  • Re: Completely baffled on what should be simple
    ... the same thing I previously did, changing format to custom ... sort, it didn't work. ... if a cell contains the text ...
    (microsoft.public.excel.misc)
  • Re: Completely baffled on what should be simple
    ... And remember just changing the format of the cell won't change the underlying ... sort, it didn't work. ... for the extensions that have either one or two 0's as the first numbers, ...
    (microsoft.public.excel.misc)
  • Re: Sane Syntax
    ... It's sort of like a game of telephone - if converting ... I don't know much about DocBook, but tsy's "Super DocBook" format does ... capability for visual markup, ... material before it was typeset. ...
    (comp.text.tex)
  • Re: Sort order - Data midified / Created
    ... What you suggest is a kludge to get around a Windows flaw. ... on the sub heading "Change the date, time, or number format" On the Formats ... All I do is click on the column header and the sort happens, ...
    (microsoft.public.windows.vista.general)
  • B-Tree Index Usage
    ... to write programs using/abusing an editor instead of the proper programming ... By the way my latest testing indicates that a Sort will not use a date index ... interpretation betwwen ACCESS and a program. ... to get the proper format the program DM,BP, DATE will still give one the ...
    (comp.databases.pick)