Counting business days

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • keithsimpson3973
    New Member
    • Aug 2006
    • 63

    Counting business days

    I have a scheduling application written in VB 6. I have code that writes an event to the Microsoft Office Outlook Calendar. I need to set the timer on the calendar event to notify 3 days later. The problem is, how do I omit weekends and/or holidays so they are not part of the 3 day time period allowed.

    Thanks a bunch!
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Originally posted by keithsimpson397 3
    I have a scheduling application written in VB 6. I have code that writes an event to the Microsoft Office Outlook Calendar. I need to set the timer on the calendar event to notify 3 days later. The problem is, how do I omit weekends and/or holidays so they are not part of the 3 day time period allowed.
    Is it a function of Outlook or VB that you need? VB has functions that let you do things like adding/subtracting days, and you can get the weekday of a date, so it should be simple enough to only count those where Weekday(MyDate) is within the appropriate range.

    Comment

    Working...