Default Date

J

Jose Aleman

Hi,

Under Default Value on a date field, I want the current date to
automatically appear but I don't want the seconds because it affects my
reports.

I put mm/dd/yyyy under formats but that doesn't work. Can someone help or
if this even possible?
 
R

Rick Brandt

Jose said:
Hi,

Under Default Value on a date field, I want the current date to
automatically appear but I don't want the seconds because it affects
my reports.

I put mm/dd/yyyy under formats but that doesn't work. Can someone
help or if this even possible?
Click to expand...

Enter =Date() in the DefaultValue property. Date() does not include time
whereas Now() does. Formatting is irrelevent to this issue.
 
Top