>when i do and insert in a table i do it this way
>

>TEXT TO SQLCOMMAND NOSHOW PRETEXT 7
>     	INSERT INTO TB_ARINV (TR_ZEBRAINVID,TR_DUEDTE)
>     VALUES (<<ARINV.ZEBRAINVID>>,'<<ARINV.DUEDTE>>')
>ENDTEXT

>
>the arinv.duedte is a date. so if the date is 08/08/2006 it will be ok in the sql server but i will have 12:00:00 for the hours. there is a way to skip this part ???

As Borissov stated you will have the 12:00:00 tacked onto the date in SQL Server.

Here is an example of a way to convert SQL Server Dates for use within a VFP Select statement:

ldDate = Thisform.cntStartDate.txtDate.Value

ldDate = CTOD(ldDate)

ltDateTime = DTOT(ldDate+1) – 1

SELECT * ; 
	FROM cuDetail ;
	WHERE cuDetail.CreatedDate <= ltDateTime ;
	into cursor cuCumulativeTotal 
	

Tom