Help with time formatting.Please!

D

Dupatt

Is there a way to set a time field default (in table) to Now() and have it
round to the nearest hour?
 
J

John W. Vinson

Is there a way to set a time field default (in table) to Now() and have it
round to the nearest hour?
Click to expand...

No, because those are incompatible tasks! Now() returns the time to the
nearest second (actually a few microseconds), regardless of the formatting.

Try setting the default (in the form, you can't use custom functions in a
table) to

=CDate(Format(Now(), "mm/dd/yyyy hh:\0\0"))

John W. Vinson [MVP]
 
D

Dupatt

Thank you.
The problem with that is I don't want everything in the field that way; just
the ones appended from another table.
 
Top