The CTOD function can only convert particular string formats to a date. If it does not recognize string as a date it returns empty date.

Try

CAST(STREXTRACT(lcStr, "", SPACE(1)) AS D)

>
>I want to transform a caractere expression to a date Format.
>Please see attachment because i have a strange result.
>
>

> m.dte_Sortie =  CTOD( TempCrystal.ddepart )
>

>
>TempCrystal.ddepart is not empty and m.dte_Sortie give a empty string !?
>thank in advance For help
>
>bernhart