I need to automatically insert today's date into a datetime field but ensure the time part is blank so the result is like '2011-02-23 00:00:00:000'. Does anyone know how to use the GETDATE() function to format this so the time is blank? Also does anyone know why the application won't edit the record because the time part is entered? Thanks!!!!