CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Erro Date

Print topic Send  topic

Author Message
Francisco
Posted: 05/10/2002, 6:31 AM

Se eu entro com a data 30/05/2002 da o erro abaixo:

"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. (Microsoft OLE DB Provider for SQL Server) "


Como consertar????

Se eu entro a data 05/30/2002 da certo!
Mas eu tenho que entrar com a data 30/05/2002...

Obrigado!
Nicole
Posted: 05/13/2002, 2:27 AM

Francisco,
the error occurs when db date/time format doesn't match date/time format passed to db. Once db date format is mm/dd/yyyy you should convert date to this format before entering it to db.
You can refer to following article to find how to convert dates: http://www.gotocode.com/art.asp?art_id=132&

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.