Default Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
Back
Top