Help with time formatting.Please!

[Dupatt]

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

 

[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?

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]

 

[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.

 

[John W. Vinson]

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

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

John W. Vinson [MVP]

 

[Dupatt]

Thanks, I will try that. I love your news groups. You guys and gals are
great.

 

[Dupatt]

I am so happy. It worked well putting it into the append query. Thanks
again.