Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    39

    Unanswered: Query to count holidays

    Hi,
    I'm working on a helpdesk project and I require the calculation of the holidays.
    I need to get the time difference of the assigned date and the solved date of the helpdesk tickets considering the week-end holidays and statutory holidays. Is there any possible way to do this. I need something similar to the NetworkDays function in excel.
    Thanks.
    Madhavi.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    I did something similar in a previous life. I created a master calendar table with columns for the date plus flag (bit) columns for weekends and holidays (and a third flag as I recall called working day). I then created a user-defined function which would take two dates as an input and return the number of "work" days elapsed between the two.

    Perhaps not elegant, but it did work.

    The master calendar table was also useful for reporting purposes. In your case, you might want a front-end interface to edit the calendar and identify which days are working versus non-working.

    Regards,

    hmscott

    Quote Originally Posted by madhavi28
    Hi,
    I'm working on a helpdesk project and I require the calculation of the holidays.
    I need to get the time difference of the assigned date and the solved date of the helpdesk tickets considering the week-end holidays and statutory holidays. Is there any possible way to do this. I need something similar to the NetworkDays function in excel.
    Thanks.
    Madhavi.
    Have you hugged your backup today?

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Only way since holidays are uniqu to countries....

    works well though
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •