Thread: Business days

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    2
    Rep Power
    0

    Business days


    Want PL/SQL help to do the following.

    I want to add 15 business days from today while I query. How do I do this?

    Any help appreciated.

    Thanks!
    Last edited by sowsam; October 1st, 2003 at 05:36 PM.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    68
    Rep Power
    11
    Since a business week is usually considered to be Monday through Friday which are 5 days, 15 days would be exactly three weeks. Meaning sysdate+21 should give you the proper date. Now, what about holidays? That makes it more complex.

    Good Luck,
    Dan
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    2
    Rep Power
    0
    Thanks! Dan. This should help. And we are not considering a holidays table.. thanks again.

IMN logo majestic logo threadwatch logo seochat tools logo