Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    178

    Unanswered: find week days in query

    i want to be able to find all the weekdays between to date in a query so i can run a report off that query. can any1 help

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Vague question.....vague answer:

    Code:
    SELECT * FROM myTableName WHERE SomeDate BETWEEN #" & Me.StartDate & "# AND #" & Me.EndDate & "#;"
    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  3. #3
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    For Week Day pehaps this

    Code:
    SELECT * FROM myTableName WHERE SomeDate BETWEEN #" & StartDate & "# AND #" & EndDate & "# AND (Weekday(SomeDate)>1 AND Weekday(SomeDate)<7);"
    ??

    MTB

Posting Permissions

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