ODBC Error (1 Viewer)

jedder18

Just Livin the Dream!
Local time
Today, 16:43
Joined
Mar 28, 2012
Messages
135
I've attached a pic of error message coming from running a query.

Any insight? I'm not familiar enough with DB's connected with ODBC.

The field in table is setup as a date/time field.
 

Attachments

  • odbcerror.jpg
    odbcerror.jpg
    37.7 KB · Views: 98

Ranman256

Well-known member
Local time
Today, 19:43
Joined
Apr 9, 2015
Messages
4,339
are you using date/time in an SQL table set as Date/time?
are you doing any math or conversion on a date field?
 

kevlray

Registered User.
Local time
Today, 16:43
Joined
Apr 5, 2010
Messages
1,046
From the error message. It appears that the field is a text field trying to convert to a date/time field. But the format is not correct, thus MS-SQL does not know how to convert it.
 

jedder18

Just Livin the Dream!
Local time
Today, 16:43
Joined
Mar 28, 2012
Messages
135
We exported the data to a new db and got it working how we needed.
Was almost 400k records so tough to find that 1 record that was not a date/time.
As far as I know, no math or conversions...but, I'm not sure of the background db. It was a sql db.
Thanks for the help.
 

kevlray

Registered User.
Local time
Today, 16:43
Joined
Apr 5, 2010
Messages
1,046
In the past I would sort a table by the date (asc and desc), generally the bad dates will be pretty noticeable.
 

Users who are viewing this thread

Top Bottom