ok i just noticed that it does create the time /date when i manually insert a new record.
my code to create the record is using c#
DatabaseLayerDataContext db = new DatabaseLayerDataContext();
try
{
Comment comments = new Comment();
comments.Title = ddlTitle.SelectedValue;
comments.FirstName = txtFirstName.Text;
comments.LastName = txtLastName.Text;
comments.Message = txtMessage.Text;
db.Comments.InsertOnSubmit(comments);
db.SubmitChanges();
lblDisplayMessage.Text = "Thank you for your message. We will deal with this as soon as possible.";
}
catch (Exception err)
{
lblDisplayMessage.Text = "An error occurred - please try again later. Thank you for your patience.";
Console.WriteLine("{0}", err.Message);
}