>>>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?