Hello

I have table in my database which has many date fields. Of which two are dupdate and dcreate where
dupdate = datetime(2000,10,10,12,00,00)
dcreate = datetime(2000,10,01,12,00,00)

This program works with different backends such as VFP, MSSQL, Oracle, Sybase

If I use a view I can change the datatype property to 'D' as the datatype on the server is datetime by using the following command where v_cust is the viewname.
dbsetprop('v_cust.dcreate','field','datatype','D').
Expression 'v_cust.dupdate - v_cust.dcreate' returns me the value of 10 (10 days)

If I use a SPT cursor I can't change the datatype to 'D' which is type 'T' in the database.
Expression 'v_cust.dupdate - v_cust.dcreate' returns me the value of 777600 (777600 seconds).

So my problem is : (I want to get the difference in number of days when using the SPT cursor but the modification I want to do is on the cursor and not the expression used.)
Is there a way to change the datatype of a field in the cursor?
Is there any other simple way to tackle this problem?

I can put some code before/after the creation of the cursor to solve this problem but I don't want to change the code where the comparision is used.

Thanks
Ajay