Re: Help, I can't find the right code

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Thu, 19 Jul 2007 05:46:00 -0700, Michelle
<Michelle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi

Well because I didn't know that you could put them both in one field. When I
look at the formats for the date/time it shows the general date option which
does have both however it shows the time using am/pm and I need it to be in
military format cause we are a healthcare institution. If I can do them both
in one field, please let me know how and I will certianlly try to do it that
way. Thanks for the help!

Note that you are NOT limited to the named formats. You can use a format such
as

"dd-mmm-yyyy hh:nn"

to show a time like

19-Jul-2007 14:22


John W. Vinson [MVP]
.

Relevant Pages

  • Re: Find Max Value of Text Field
    ... separate fields. ... there are really only three formats for the revision - it may be 01, ... John W. Vinson [MVP] ...
    (microsoft.public.access.queries)
  • Re: Time Format in Excel
    ... Access date/time fields store points in time encoded as real numbers. ... Duration = EndTime - SetupTime ... depending on the date/time formats you're using!). ... I want to Sum the duration column into a total number of hours. ...
    (microsoft.public.access.externaldata)
  • Re: Sql mdb
    ... program on a PC in a different country - or on a PC with different date/time separators or formats. ... Better to use the ISO formats "YYYY-MM-DD" which are unambiguously understood by both SQLserver and MSAccess ... // this PC's "TimeSeparator" - so we need to check if it has been altered from ":" ... function TimeToDatabaseString ...
    (borland.public.delphi.database.ado)
  • Re: SQL Statement BETWEEN 2 Dates - Advice Please.
    ... Stop using ambiguous date formats! ... (Reverse address to reply.) ... > The access MDB has the 'IDate' formated as Date/Time. ...
    (microsoft.public.inetserver.asp.db)
  • Re: How to capture last used date/time
    ... store the date/time, and write some code to write to ... John W. Vinson [MVP] ...
    (microsoft.public.access.gettingstarted)