Results 1 to 4 of 4
  1. #1
    LisaEllen is offline Novice
    Windows Vista Access 2003
    Join Date
    Sep 2011
    Posts
    22

    Query-Expression with Dates Looking for Business Days

    Hello, I have a query that is subtracting two dates and giving me the number of days between the two - it is also counting weekend days which I don't want - is there a way to put something into the expression that will make this only include business days? Thank you for any help. Lp

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,587
    Show us what you have in your current query --sql view.

    see Steve's post here

  3. #3
    LisaEllen is offline Novice
    Windows Vista Access 2003
    Join Date
    Sep 2011
    Posts
    22
    SELECT [Client Name].[BNY Client Number] AS Client, [Audit Detail].[Review Date], [Audit Detail].AE_resp_recd, [Audit Detail].CO_resp_recd, ([Audit Detail].[AE_resp_recd]-[Audit Detail].[Review Date]) AS [RM Bus Days to Respond], ([Audit Detail].[CO_resp_recd]-[Audit Detail].[Review Date]) AS [CO Bus Days to Respond]
    FROM [Client Name] RIGHT JOIN [Audit Detail] ON [Client Name].[BNY Client Number] = [Audit Detail].[Client Number];

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,669
    Do you also need to account for holidays? Review http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Dates before 30 days
    By fabiobarreto10 in forum Queries
    Replies: 7
    Last Post: 04-20-2012, 12:11 PM
  2. CRITERIA only looks at the LAST 20 BUSINESS DAYS
    By taimysho0 in forum Queries
    Replies: 3
    Last Post: 12-06-2011, 06:27 PM
  3. Dates & Days Fields
    By djclntn in forum Database Design
    Replies: 5
    Last Post: 10-22-2011, 06:22 PM
  4. Replies: 4
    Last Post: 09-06-2011, 02:20 PM
  5. Select Dates between days and two days ago?
    By rstonehouse in forum Queries
    Replies: 4
    Last Post: 08-18-2010, 02:13 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
  •  
Tech Forums: Microsoft Office Forums