yes serg i use the OLEDB driver for VFP 9.

Still this code has an error result

Select   *
  FROM OPENQUERY( LNK_VINS,
     'SELECT CAST(EVL(chkdate, NULL) AS date) 
        FROM paytran where !deleted()')
order by 1
-------------
Server: Msg 8114, Level 16, State 10, Line 1
Error converting data type DBTYPE_DBDATE to datetime.

I serg resolve it but i think it not a good idea. I really what cause the error.

Select *
FROM OPENQUERY( LNK_VINS,
   'SELECT 
	   ALLTRIM(STR(YEAR(chkdate))) + "-" + ALLTRIM(STR(MONTH(chkdate))) +"-" + ALLTRIM(STR(Day(chkdate))) as chkDate FROM paytran where !deleted() ')