Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Forms

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-19-2005, 06:38 AM
Novice
 
Join Date: Dec 2005
Location: USA
Posts: 9
playfuljade
Send a message via Yahoo to playfuljade
Default 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?
Reply With Quote
  #2  
Old 12-19-2005, 08:04 AM
Advanced Beginner
 
Join Date: Dec 2005
Posts: 99
StepUP
Default

Format(Now(),"mmddyyhhmm")
__________________
John F
Reply With Quote
  #3  
Old 12-19-2005, 08:44 AM
Novice
 
Join Date: Dec 2005
Location: USA
Posts: 9
playfuljade
Send a message via Yahoo to playfuljade
Default date/time number

Thank you again John!
Reply With Quote
  #4  
Old 12-19-2005, 09:37 AM
Novice
 
Join Date: Dec 2005
Location: USA
Posts: 9
playfuljade
Send a message via Yahoo to playfuljade
Default 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.
Reply With Quote
  #5  
Old 12-19-2005, 09:52 AM
Novice
 
Join Date: Dec 2005
Location: USA
Posts: 9
playfuljade
Send a message via Yahoo to playfuljade
Default date/time number

Got it John. Mondays...lol

Thanks again for the info.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Date Into Number greenbag Queries 0 11-14-2008 01:43 PM
Time and date serch gayano Access 0 07-05-2007 05:59 PM
date/time field James890 Database Design 1 04-18-2007 05:51 AM
Using alphabets, numbers and date to make a serial number izyan Forms 5 02-08-2006 05:42 PM
Access Date/Time....I need a "generic" date. beastmaster Access 2 12-29-2005 09:55 AM


All times are GMT -8. The time now is 02:54 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.