D Dupatt Jun 25, 2007 #1 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?
J John W. Vinson Jun 25, 2007 #2 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]
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 Jun 25, 2007 #3 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.
J John W. Vinson Jun 25, 2007 #4 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]
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]
D Dupatt Jun 26, 2007 #5 Thanks, I will try that. I love your news groups. You guys and gals are great.
D Dupatt Jun 26, 2007 #6 I am so happy. It worked well putting it into the append query. Thanks again.
