Home Forums SQL Server 2005 T-SQL (SS2K5) Number of weeks between two dates RE: Number of weeks between two dates

  • January 7, 2011 at 2:46 am

    #1270509

    SELECT DATEDIFF(dd,'2010-APR-01','2010-DEC-01') / 7

    OR

    SELECT DATEDIFF(wk,'2010-APR-01','2010-DEC-01')

    Is this the question?