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