I am running into a problem where we cannot use DateTime in SQL.

I have a field that I have called Date_Created and have set it to data type datetime. The field in auto populated on the page with the year and is Read Only. When you add the record nothing gets added. If I chance the field to char or nvarchar the record will be added with the date. But I want to use datetime.

Any ideas what could be causing this.

Thanks, Carl