Try

'SELECT CAST(EVL(chkdate, NULL) AS datetime)
        FROM paytran where !deleted()')

>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() ')
>