Date fields

[Larry]

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.

 

[Duane Hookom]

What do you mean by "serial format"? What do you want to convert?

 

[John Vinson]

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]