Default Date

[Guest]

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?

 

[Rick Brandt]

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?

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

 

[Guest]

Never mind. I got it.

When you entered Date() instead of Now()