ODBC Error

[jedder18]

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.

 

[Ranman256]

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]

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]

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]

In the past I would sort a table by the date (asc and desc), generally the bad dates will be pretty noticeable.