View Single Post
  #2 (permalink)  
Old January 11th, 2011, 12:53 PM
Jeff Moden Jeff Moden is offline
Friend of Wrox
Points: 1,536, Level: 15
Points: 1,536, Level: 15 Points: 1,536, Level: 15 Points: 1,536, Level: 15
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2006
Location: , MI, USA.
Posts: 475
Thanks: 0
Thanked 9 Times in 9 Posts
Default

SELECT DATEDIFF(dd,'2010-12-25','2011-1-25')

Your choice as to whether to add "1" to that or not.
__________________
--Jeff Moden

Last edited by Jeff Moden; January 22nd, 2011 at 01:01 PM..
Reply With Quote