Subject Re: [IBO] conversion error from string "2002-02-14".
Author Helen Borrie (TeamIBO)
At 10:08 AM 01-02-02 -0800, you wrote:
>I can edit a record via an SP without getting the error below when I post.
>When I insert into the same table, I get the following error:-
> conversion error from string "2002-02-14".
>I have the shortdateformat set to 'mm/dd/yyyy' in my app.

this really doesn't tell us anything useful.
What version of the database are you using?
What are you using to do the insert?
Do you have an SQL statement you can show us?
Do you have the line(s) of Delphi code where the date is assigned?
What EXACT data type is the database column to which the value is being pushed?
Do you have any monitor output you can show us?

please please please, Dear People, provide enough information so that we don't have to have an inquisition every time you post a problem.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at