Excluding weekend dates from calculated data pull

I have a business need to display some date specific data to a selcect group
of users 3 bussiness days before everyone else is allowed to see it.

THere are many fields I will be displaying across many tables. The date I am
using is ONLY in the primary table (meaning I don't have to include or
exclude data based on a date match from the other tables).

What I need to know is if there is a way in the SQL Query to not count the
weekend days as part of the 3 bussiness days. My query right now uses "WHERE
datafield < (GetDate + 5)". But this lets the users see data for the week's
Friday on the week's Monday. Not acceptable. If I only use "WHERE datafield <
(GetDate + 3) Then data to been displayed on This week's Tuesday can not be
seen on the previous Friday. Also Not Acceptable.

Any ideas?

Thanks.
--
Carrie E. Wells
Web Architect/Developer

Oh, and if Ihave this posted int eh wrong place tell me where to put it an I
move it.
.

Relevant Pages

  • Wanted: Data East Rocky & Bullwinkle Dot Matrix & Driver Board
    ... I just bought a Rocky and Bullwinkle from an operator that ... went out of bussiness 7-8 years ago. ... He had pulled the dot matrix ... display and display driver board out for repair along time ago but ...
    (rec.games.pinball)
  • Re: [PHP] Counting Occurrences within an If statement
    ... statement in the SQL query so you don't return so many rows. ... I am pulling 7500 rows from a MySQL database, but I only want to display a ... display a row in a table ...
    (php.general)
  • Re: Combo box question
    ... Rowsource to "table.field1, field2" ... If you don't want to display the id field, set the width of that column to ... can use it in your sql query. ...
    (microsoft.public.fox.vfp.forms)
  • Performing an SQL query in VBA
    ... I need to perform a SQL query in VBA and display the result in a ... txtLName_Changeevent and display the result in txtNum. ... just getting it to a textbox is great. ...
    (microsoft.public.access.gettingstarted)
  • Re: SQL query: how can I hide a column in output?
    ... I've the following SQL query: ... Actually, I need the alias client_no for further processing, but I ... You are not required to show that column, but your SELECT clause needs to show at least one column. ... If you are writing your own application, you do not have to display the column's value in that application if you do not want to. ...
    (comp.databases.oracle.server)