Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    Paris, FRANCE
    Posts
    132

    Post Unanswered: SELECTing working days

    I'd like to get the list of working days between to dates without having to use my script langage.
    This is in order to LEFT JOIN it to a table containing some figures by day.

    Example:
    between 2005-12-18 and 2005-12-25
    Here are my figures
    Code:
    2005-12-20 | 5
    2005-12-22 | 3
    2005-12-23 | 2
    Here is what i'd like to have generated (working days between 2005-12-18 and 2005-12-25)
    Code:
    2005-12-19
    2005-12-20
    2005-12-21
    2005-12-22
    2005-12-23
    Here will be the LEFT JOINt result
    Code:
    2005-12-19 |
    2005-12-20 | 5
    2005-12-21 |
    2005-12-22 | 3
    2005-12-23 | 2

  2. #2
    Join Date
    Apr 2005
    Location
    Lier, Belgium
    Posts
    122
    Quote Originally Posted by gtk
    I'd like to get the list of working days between to dates
    Use a calendar table. See http://www.dbforums.com/t981086.html
    --
    felix

Posting Permissions

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