>>>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only