>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
Specifying what for datepart?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people