Thanks Cetin,

I am not using RV but using SPT.

MyConn=SQLCONNECT('ConnectDSN',"UN","PASS")
SQLEXEC(MyConn,"Select FinFromDate,FinToDate from FinYear","CurFinYear")

Both the fields FinFromDate,FinToDate are of Date Datatype in Oracle returning me a Time Datatype in VFP 7.0.

As u suggested :
DBSETPROP("CurFinYear.FinFromDate","FIELD","DATATYPE",'D')

Gives the following error:
Function argument value, type, or count is invalid (Error 11)

Any further suggestion.

Regards,

Aashish




>>Dear Friends,
>>
>>
>>While taking a Date Datatype value from Back-End(Oracle) to Front-End (VFP 7.0)
>>It convert the Date OF Oracle To VFP DateTime DataType.
>>
>>Any way by which i can get only date Datatype in Front-end.
>>
>>Thanks
>>
>>Aashish
>
>You can change datatype either in RV properties or using dbsetprop()
>DBSETPROP('myview.myfield', 'field', 'DataType', 'D')
>Cetin