'SELECT CAST(EVL(chkdate, NULL) AS datetime) FROM paytran where !deleted()')>yes serg i use the OLEDB driver for VFP 9.
>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. > > >>
>Select * >FROM OPENQUERY( LNK_VINS, > 'SELECT > ALLTRIM(STR(YEAR(chkdate))) + "-" + ALLTRIM(STR(MONTH(chkdate))) +"-" + ALLTRIM(STR(Day(chkdate))) as chkDate FROM paytran where !deleted() ') >