>How do I calculate the number of days between two dates in SQL?
>
>

>SELECT APM_InvoiceDate - APM_DiscDate AS [VR-DSC-DAYS]
>	FROM iERP72_Test.dbo.APM
>

>
>This returns a datetime

DateDiff ?

See first example http://msdn.microsoft.com/en-us/library/ms189794.aspx