I ironvid Registered User. Local time Today, 14:28 Joined Aug 14, 2003 Messages 18 Sep 22, 2003 #1 I am designing a table and I need one of my columns to automaticlly enter the date in when a record is created. In MSSQL i Simply add (getdate()) into the default Value Thanks for any help Regards....stephen
I am designing a table and I need one of my columns to automaticlly enter the date in when a record is created. In MSSQL i Simply add (getdate()) into the default Value Thanks for any help Regards....stephen
Mile-O Back once again... Local time Today, 14:28 Joined Dec 10, 2002 Messages 11,316 Sep 22, 2003 #2 Stick: =Date() in the default value. or =Now() if you want the date and time.