>the problem is im using another language ( WINDEV )
>and im using the oledb from foxpro
>
>champdate est une chaîne = "{0001-01-01;00:00:00 a.m.}"
>srequete = "insert into connection (IDFILE,descr,cpath,DTE_IN) values ("+dossier+",'"+descr+"','"+path+"','"+champdate+"')"
>
>this is my code
>
>in want to put it in string but i doesnt know the good format for the datetime field

Did you check the help and samples for CTOT() function? It may help you.

As an example, this will be correctly converted to datetime:

SET DATE YMD
CTOT("2000/10/24 13:30:00")

So you can try format the datetime string according to your SET DATE on VFP side and pass it through.