Post reply

Find number of Weeks

  • October 2, 2007 at 9:11 am

    #175620

    I have two dates i need to find out how many weeks are between these two dates so i start with 2/10/07 subtract 01/04/07 . how do i do this caluculation in Reporting services

  • October 2, 2007 at 10:03 am

    #738250

    I have managed to to this thanks you

  • October 2, 2007 at 10:04 am

    #738251

    To do this in a VB Expression use DateDiff and set the interval to return the result in weeks.

    Or you can use datediff in SQL (it works much the same way see BOL) if you need the result in the dataset. I prefer to do this as it keeps the logic together.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply