View Single Post
  #2 (permalink)  
Old October 16th, 2006, 04:56 PM
rstelma rstelma is offline
Friend of Wrox
Points: 2,101, Level: 18
Points: 2,101, Level: 18 Points: 2,101, Level: 18 Points: 2,101, Level: 18
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2003
Location: , , .
Posts: 599
Thanks: 6
Thanked 3 Times in 3 Posts
Default

Peso has written a very fine function that should do the trick for you. I've been able to use it for a number of date interval/period queries and calculations.

http://www.sqlservercentral.com/colu...tiliretire.asp



Reply With Quote