I'm getting the error below:
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. The statement has been terminated.
I have an asp.net page and an sql2000 dB with the updated field set as smalldatetime, when I save the web page, i want the updated field to have todays date.
How do i do this?