Hi Kevin,

One method would be to use the T-SQL DATEDIFF ( datepart , startdate , enddate ) function.

Bill

>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