>>>>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.
>>>>
>>>
>>>Check out the DatePart() function in SQL Books Online.
>>
>>I can get the format as I want but only in a form of String but not as a date datatype.
>
>Yep, I realized this after I sent it - that's why I followed up with the DateDiff() suggestion :)
>
>BTW - Did DateDiff() work for you?

Datediff() : I will have to apply it on the backend and it will return me the number of days i.e. integer value. As I mentioned I want to recieve a date value which I can use in VFP to calculate the difference from other date value.