An overflow occurred while converting to datetime

Replies to This Discussion

Permalink Reply by Keith Govender on January 25, 2012 at 3:25pm

A syntax error is caused when you put values in wrong places when converting or  trying to convert a value to a date value.

You will need to get a consultant to show you how to convert to Date format correctly.

CUSTOMISED REPORTS

For the list of certified consultants for Report Customisation, please go to the following link on our website: http://www.alchemex.com/FindABusinessPartner.aspx

• Select Certified Professional Consultant from the “By Partner Type” drop down
• Specify the Country  as well as State.
• Then select Find button.

I have also sent you some links to reference the error.

 

 

http://stackoverflow.com/questions/6730859/an-overflow-occurred-whi...

 

 

http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/aa5eba37...

 

 

http://forums.asp.net/p/1753771/4753446.aspx/1?An+overflow+occurred...

 

 

http://forums.create.msdn.com/forums/t/93413.aspx

 

 

http://www.bigresource.com/MS_SQL-An-overflow-occurred-while-conver...

 

 

http://www.dotnetspark.com/links/49424-overflow-occurred-while-conv...

• ▶ Reply