Date Conversion

[deucesp97]

I am using QMF to convert a character type into a date type.
Is this possible, if so how?

I have tried a few things but the recent is
SELECT DATE(ROUTE_DT)
FROM INVOICE;

The error message I am receiving is the datetime value is invalid. [sig][/sig]

 

[MalcolmW]

SELECT ROUTE_DT
FROM INVOICE
WHERE ISDATE(ROUTE_DT) = 0
will often tell you what dates are giving you problems.
[sig][/sig]