Get The Date

Hi all,

I am trying to get the date difference from the day it being orders to the date it being shipped.

I am doing something like this, but it still returns the wrong result:

DaysLate=CONVERT(INT,DATEPART(dd, o.DueDT))-CONVERT(INT,DATEPART(dd,GetDate()))

Is anyone can help me with this?

Thanks in advance.

try,

DATEDIFF(d, oDueDT, GETDATE())

|||Thanks...