Error converting nvarchar to datetime

Mar 16, 2009 at 4:07 PM
Edited Mar 16, 2009 at 4:23 PM


When i select timesheet tab, i have the message "Error converting nvarchar to datetime".

I've tried to change system date format but nothing works.

I work on windows server 2003 french, sql server 2005 french and tfs 2008 french.

Someone have an idea ?


Mar 16, 2009 at 11:16 PM
I was converting various DateTime values to yyyy-MM-dd strings prior to passing them into stored procedures.  You may have the SQL date format set to something other than yyyy-MM-dd which would have caused this error.  These values are now passed into the procs as they are which should avoid these internationalization issues.  Download, compile, and deploy the latest code from the source tab and let me know if this fixes your problem.
Mar 17, 2009 at 7:30 AM
Edited Mar 17, 2009 at 6:12 PM

Thanks for your reponse.

Yes, your last check in resolved my problem. It will be interesting to put it in a release :)

Mar 18, 2009 at 1:26 PM
Glad to hear it, thanks for the report.