Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: Help display results for current week only!

    I wanted to display all results from a table for the current week (Monday - Sunday).

    SELECT *
    FROM Events
    WHERE Event_Date .... falls in the current week.

    Any help on this would be greatly appreciated!

    Thanks,
    Nate

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't have any way to test it, but the DayOfWeek(), DateAdd(), and DateSub() functions should get you there.

    -PatP

Posting Permissions

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