I have an Access 2007 ADP with a SQL 2008 database. I am trying to insert either the current date or the date from one of my fields with an Update Query/Stored Procedure into a DateTime field with the desired result of mm/dd/yyyy format. However no matter how I have tried to format the NOW() function or DATE function within VBA I get the result of 12:00:00 AM or some error message. I have tried Format and Convert, but maybe not the right combinations. Suggestions?