Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Question Unanswered: Working dates minus public holidays

    Hey,

    I need the following to work:

    Date1 - Date2 = No of days

    I need the number of days to only include weekdays and minus English public holidays.

    If anybody is kind enough to help please don't assume I know too much about Access!

    Thanks in advance

    Fraser

  2. #2
    Join Date
    Apr 2003
    Location
    Alabama, USA
    Posts
    154
    Try this. Not my own code, mind you. However, this requires that you use code and it doesn't sound like you are comfortable with using code.
    http://AccessDB.Info

    You live and learn. At any rate, you live. - Douglas Adams

  3. #3
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    There is a poster on that same sight and his handle is something like Raskew and he seems to have a made a bit of a speciality on dates. In addition he shows you exactly where to post the code and then what to enter in a new query field to work the code.

    One really great thing he had was the difference between two dates and the results was like

    37 years, 8 months, 8 days

    Mike

Posting Permissions

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