You're welcome.

BTW,Vlad gave you similar suggestions in the message #1391978 earlier.

>
>You must Do VFP 10 !...:)
>
>big thank sergey
>
>>You've to get rid of the time part first and then use CTOD or CAST
>>

>>m.dte_Sortie = CAST(STREXTRACT(TempCrystal.ddepart, "", SPACE(1)) AS D)
>>

>>>
>>>here is a part of the sql request...
>>>
>>>E.ddepart is a datetime Expression that converted in a caractere expression with "TRANSFORM( E.ddepart ,"@E" ) AS ddepart,"
>>>
>>>now i want convert to this Field To a date Format ( CTOD() ).
>>>
>>>

>>>
>>> E.nType = CA_LOC 		, cCA_LOC ,;
>>>   E.nType = RS_LOC 		, cRS_LOC , ;
>>>   E.nType = CS_LOC 		, cCS_LOC , '' ) , 4 ) AS 'cType',;
>>>   TRANSFORM(  E.ddepart ,"@E" ) AS ddepart,;
>>>   TRANSFORM(  E.dretour ,"@E" ) AS dretour,;
>>>   E.nPosCat,;
>>>   E.ncause,;
>>>   E.nType = CS_LOC AS lcourtsej ,;
>>>   c.cpseudcode,;
>>>
>>>

>>>