Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2003
    Location
    Kansas City, Kansas, USA
    Posts
    76
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Calculate Date Fields (2000)

    Hello, I need help with date fields. I have a table that holds the date that we receive paperwork, and a date that the paperwork has been processed. I need to know how to find out how many work days have past between the two dates.
    Any suggestions?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculate Date Fields (2000)

    Use a query and add the two dates.
    Add a column and enter :
    ProcessDays : DateDiff("d",DateDelivered,DateProcessed)
    Replace your two date field names with your field names.
    Francois

  3. #3
    Star Lounger
    Join Date
    May 2003
    Location
    Kansas City, Kansas, USA
    Posts
    76
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Calculate Date Fields (2000)

    Thank you so much! How simple.......
    It is very appreciated.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculate Date Fields (2000)

    DateDiff is a very useful function, but it simply subtracts two dates. It does not take weekend days into account. You need VBA for that - see Date/Time: Doing WorkDay Math in VBA.

  5. #5
    Star Lounger
    Join Date
    May 2003
    Location
    Kansas City, Kansas, USA
    Posts
    76
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Calculate Date Fields (2000)

    Thank you Hans, That worked perfectly. ...

Posting Permissions

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