Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Feb 2001
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    First Business Day of Month (97 sr2)

    Is there an easy way to find out the first business day of the month. Maybe using DateSerial??

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: First Business Day of Month (97 sr2)

    You're on the right track. When you get the date out of DateSerial, pass it to DatePart and

    do
    loop until "test for your definition of 'Business day'"

Posting Permissions

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