[thelist] SQL query to create aging buckets

[Joel D Canfield]

<quoth Joshua Olson:>

	The answer may be easier than you think.
	
	SELECT datediff(d,duedate,getdate()), Count(*) AS TheCount
	FROM tasks
	GROUP BY datediff(d,duedate,getdate())
	

	</jo>

	Hot diggity! Shoulda thunk of that meself

	joel