Results 1 to 2 of 2
  1. #1
    cs93 is offline Novice
    Windows XP Access 2000
    Join Date
    Mar 2011
    Posts
    6

    DateDiff Excluding Weekends

    Hi


    I want to calculate the number of dates between two fields in a form, but exclude weekends. I have heard a DateDiff function will not do this, is there any other (preferably simple) method to do it? (I have almost zero knowledge in vb).

    Thanks
    cs93

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664

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

Similar Threads

  1. how to filter weekends
    By pranvera in forum Access
    Replies: 17
    Last Post: 10-19-2010, 05:10 AM
  2. Another removing weekends question
    By catguy in forum Access
    Replies: 6
    Last Post: 08-03-2010, 07:59 AM
  3. Weekday excluding weekends
    By jd316632 in forum Queries
    Replies: 3
    Last Post: 05-24-2010, 02:01 PM
  4. Query DateDiff calculation excluding weekends
    By Masterfinn in forum Queries
    Replies: 3
    Last Post: 04-01-2010, 09:46 AM
  5. Excluding data in a query
    By lpdds in forum Queries
    Replies: 1
    Last Post: 12-16-2009, 08:06 PM

Tags for this Thread

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