Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    mbenton's Avatar
    mbenton is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jul 2015
    Posts
    73

    I renamed my module.
    My query looks like this: Working Days: Workdays([Startdate],[enddate]). I ran it like this, also I tried putting my dates in the startdate and enddate. It says, "Undefined function "Workdays" in expression."

  2. #17
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725

  3. #18
    mbenton's Avatar
    mbenton is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jul 2015
    Posts
    73
    Thanks, however it will only give me the number of business days between two dates. I have about 10 due dates that all calculated by my "Go Live" date, I want to populate each of the 10 task due dates.

  4. #19
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725

  5. #20
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    We may be a bit confused by your last post. I thought you needed the number of workdays between two dates. Wouldn't the same procedure work for each value you need?

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Future Date that may be incremented
    By h1mself2 in forum Access
    Replies: 3
    Last Post: 12-14-2012, 04:11 PM
  2. Replies: 3
    Last Post: 11-20-2012, 01:40 PM
  3. Calculated Future Dates
    By Monterey_Manzer in forum Forms
    Replies: 5
    Last Post: 10-02-2012, 05:02 PM
  4. Future date parameter
    By normie in forum Queries
    Replies: 10
    Last Post: 08-12-2010, 09:38 PM
  5. Count Dates within Date Range
    By eckert1961 in forum Queries
    Replies: 2
    Last Post: 03-08-2009, 10:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums