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
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.