I am trying to enter the current date into my MSaccess DB when a form is submitted. I also want to be able to do the same when the form is updated. I can get the date to display Day mm/dd/yyyy time. The trouble is i dont want all of this information. Can anyone tell me how to format the date so all that is entered is MM/DD/YY? I am using a hidden field.

Using a default date in the DB itself doesnt work because an new record is created and stays empty until data is entered for it