Post reply

Calculate Days between Dates

  • October 8, 2012 at 7:53 am

    #268193

    Hi people,

    I have to calculate how many days are between 2 dates (ProjectStartDate and ProjectFinishDate) in order to retrieve TotalProjectDuration.

    Do anybody know a way to do it?

  • October 8, 2012 at 8:00 am

    #1546736

    Found the solution!

    Here it goes

    DATEDIFF(DAY, ProjectStartDate, ProjectFinishDate) AS TotalProjectDuration

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

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