Error: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

I got this error few days back when i was using SubSonic to do some Database updates. Most of the time this error occures if.

1. Date Time Format is wrong. - Always stick to yyyy-MM-dd format. it will makes life so easy
2. Check for current culture for the execution thread. if it's running in a different culture thread this error is likely to occur