Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: Help Me PL!<Wokdays>

    I want to calculate datediff for workdays displayed in hours and days. And i want to exclude holidays and saturday and sunday too!

    1. table xxxxx
    field : from_days , to_days ; both fields type datetime
    2. table holidays
    field : holiday : type datetime

    for example : from_days 6/2/2009 13:00:00
    to_days 10/2/2009 16:30:00
    holiday is 9/2/2009 and sat adn sun ==> exclude

    Thanks for all your help

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Welcome to the forums!

    Redneck has a post in the code bank that might be of some use to you.
    Me.Geek = True

  3. #3
    Join Date
    Feb 2009
    Posts
    2
    thank you nckdryr
    but it dosn't count in time(hours)

Posting Permissions

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