Hi Nicholas,
You can use something like this in the SQL Default settings under Advanced Field Options:
SELECT CONVERT( CHAR(12), GetDate(), 101) As DefaultValue
If you do a search on the internet, you'll find other formatting options. One good place is here:
http://www.sql-server-helper.com/ti...rmats.aspx Thanks!
Candace