![]() |
|
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
Format(Now(),"mmddyyhhmm")
__________________
John F |
|
#3
|
|||
|
|||
|
Thank you again John!
|
|
#4
|
|||
|
|||
|
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
|
|||
|
|||
|
Got it John. Mondays...lol
Thanks again for the info. |
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
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 |