Help with time formatting.Please!

  • Thread starter Thread starter Dupatt
  • Start date Start date
D

Dupatt

Is there a way to set a time field default (in table) to Now() and have it
round to the nearest hour?
 
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]
 
Thank you.
The problem with that is I don't want everything in the field that way; just
the ones appended from another table.
 
Thank you.
The problem with that is I don't want everything in the field that way; just
the ones appended from another table.
Click to expand...

Use that expresssion as a calculated field in the Append query that copies the
records, then.

John W. Vinson [MVP]
 
Back
Top