If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date fields
I'd like to automatically populate a field with the serial date format fo
now(). This works great for autonumbering records since the instane will never again be repeated. Unfortunately, I can't remember how to convert now to a serial format. Any help would be appreciated. |
#2
|
|||
|
|||
What do you mean by "serial format"? What do you want to convert?
-- Duane Hookom MS Access MVP "Larry" wrote in message ... I'd like to automatically populate a field with the serial date format fo now(). This works great for autonumbering records since the instane will never again be repeated. Unfortunately, I can't remember how to convert now to a serial format. Any help would be appreciated. |
#3
|
|||
|
|||
On Wed, 30 Mar 2005 09:29:03 -0800, "Larry"
wrote: I'd like to automatically populate a field with the serial date format fo now(). This works great for autonumbering records since the instane will never again be repeated. Now() returns a Double Float number, a count of days and fractional days. It's accurate to the second. As such it's ok for manually entered data, but records entered using an append query may have duplicates. There's no need (and no benefit) to making it a "serial date" - it already IS a numeric date/time value. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Import Date Fields | Otto | Contacts | 1 | December 2nd, 2004 04:26 PM |
Date form fields in Word 2003 | Andy | General Discussion | 1 | November 11th, 2004 11:06 AM |
Filtering on custom date field | MED | Contacts | 3 | September 17th, 2004 03:05 PM |
QDE (Quick Date Entry) | Norman Harker | Worksheet Functions | 37 | September 5th, 2004 01:24 AM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |