Date fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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]
 
Back
Top