Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010
    Posts
    6

    Unanswered: Help with time format needed

    Please help. I dont know the first thing to do when formatting time/date.
    i want my time field in my form to be in military time without the colon and starting with a zero.
    for example...
    1300 and 0600

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Format(YourTimeField,"hhmm")
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jul 2010
    Posts
    6
    Quote Originally Posted by Missinglinq View Post
    Format(YourTimeField,"hhmm")
    where do i put this code?

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    That's the code for displaying the formatted time in a query.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •