>>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
>
>Ok, got it:
>
>So now I want to see only those rows with Days > 0
>
>This isn't right:
>
>

>
>SELECT APM_InvoiceDate, APM_DiscDate, DATEDIFF(year, APM_InvoiceDate , APM_DiscDate) AS Days, APM_InvoiceDate - APM_DiscDate AS [VR-DSC-DAYS]
>	FROM iERP72_Test.dbo.APM
>	GROUP BY Days
>	HAVING Days > 0
>

>
>Give me 'Invalid column name 'Days'.'

SELECT APM_InvoiceDate, 
  APM_DiscDate, 
  DATEDIFF(year, APM_InvoiceDate , APM_DiscDate) AS Days, 
  APM_InvoiceDate - APM_DiscDate AS [VR-DSC-DAYS]
	FROM iERP72_Test.dbo.APM
	WHERE DATEDIFF(year, APM_InvoiceDate , APM_DiscDate) > 0

Group by is irrelevant there. If it were relevant then you would write as:

GROUP BY DATEDIFF(year, APM_InvoiceDate , APM_DiscDate)

Cetin