Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mazharuddin Ehsan Calculating the Number of Business Hours Passed Since a Point of Tme RE: Calculating the Number of Business Hours Passed Since a Point of Tme

  • January 19, 2008 at 12:29 pm

    #769962

    You can use the functions CalcTimeBetweenTwoDates & CalcTimeSinceCreated in any SQL statement, stored procedure or UDF

    For example

    select dbo.CalcTimeBetweenTwoDates(date_created, date_modified) from [Your Table]

    will give the duration between the two fields.

    select dbo.CalcTimeSinceCreated(date_created) from [Your Table]

    will give you duration passed since the case was created. You can use this function to track the duration since creation for the unresolved cases.

    Sincerely,

    Maz

    -----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]