[thelist] SQL query to create aging buckets

Joel D Canfield joel at spinhead.com
Wed Dec 17 16:04:23 CST 2003

<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())


	Hot diggity! Shoulda thunk of that meself



More information about the thelist mailing list