Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2005
    Location
    USA
    Posts
    9

    date/time number


    I would like to be able to use the current date and time in a program for the Bill of Lading number without the slashes...ect. Example: for today's date and time(military), I would like the bill of lading number to be: 1219051036. Can this be done in Access? If so, how?

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Format(Now(),"mmddyyhhmm")

  3. #3
    Join Date
    Dec 2005
    Location
    USA
    Posts
    9

    date/time number

    Thank you again John!

  4. #4
    Join Date
    Dec 2005
    Location
    USA
    Posts
    9

    date/time number

    John, where exactly would I put this? I have tried to apply it to the direct table and the field within the form, but no results yet.

  5. #5
    Join Date
    Dec 2005
    Location
    USA
    Posts
    9

    date/time number

    Got it John. Mondays...lol

    Thanks again for the info.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Change Date Into Number
    By greenbag in forum Queries
    Replies: 0
    Last Post: 11-14-2008, 04:43 PM
  2. Time and date serch
    By gayano in forum Access
    Replies: 0
    Last Post: 07-05-2007, 07:59 PM
  3. date/time field
    By James890 in forum Database Design
    Replies: 1
    Last Post: 04-18-2007, 07:51 AM
  4. Replies: 5
    Last Post: 02-08-2006, 08:42 PM
  5. Access Date/Time....I need a "generic" date.
    By beastmaster in forum Access
    Replies: 2
    Last Post: 12-29-2005, 12:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums