We have a table with a column which called 'tworkdt' which is a date field.
When we try the following select statement from our application:
select * from mytable where tworkdt > '05/05/2004', we got the following error:

ODBC--called failed. [INTERSOLV][ODBC Informix driver]
[Informix]Date could not be converted to month/day/year format (#-1210)

Any ideas why we have this error?
When I looked at the table itself, I found there are some records that got corrupted (but the tworkdt field is not corrupted, it was other fields got corrupted). We have already deleted the corrupted data from the table but still got the above error.

Thank you for all help in advance.

A true date field - or datetime?

Have you tried:
select * from mytable where tworkdt > date('05/05/2004')

Also, check your version of setnet. A lot of ODBC errors go away with new releases.