Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    1

    Question Unanswered: adding business days from a date the user selects

    Hello, I have a question. I have been searching for an answer online for the answer with no luck. Is there a simple SQL script or query expression I can use to calculate business days from a date the user inputs? I have found some different posts on how to add business days but I beleive it is showing me VBA scripting for a form which I am not quite understanding as I keep getting an error message whenever I try. Ideally what I want to achieve is there is a button the user clicks on and it runs this query which asks for a date. The user puts in the date and then the query will ask them for the interval (just for example the user says date of 1/1/09 and inputs 10 for the interval. I want the query to display 1/13/09 as this is 10 business days (Monday-Friday) from 1/1/09. Can anyone help? I have already figured out the expression that will allow me to do this with just regular days and that expression is:

    Expr1: DateAdd("d",[Enter Interval],[Enter Date])

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

    Have a look at RedNeck's post in the Codebank. Cheers.
    Me.Geek = True

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Do Public holidays matter?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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