Posted by M A Srinivas on 06/19/07 11:53

On Jun 19, 4:21 pm, roblowein <rob.low...@gmail.com> wrote:
> Hello,
>
> Please can you point me in the right direction.
>
> I have a table (JobMain) that holds a list of all jobs that out
> engineers need to work on or have worked on.
>
> I would like to select jobs that fall between Monday - Friday 8am to
> 7pm.
>
> The tables holds a load of colums ... the two that are of interest to
> me are
>
> JobId (Primary Key) - Job Number
> StartDate (Datetime datatype) - Job start date and time
>
> regards
>
> Rob

DECLARE @startdate datetime ,@enddate datetime

SET @startdate = '2007-06-18 08:00:00' -- Monday 8 AM
SET @enddate = DATEADD(DD,4 ,DATEADD(HOUR,11,@startdate)) --

SELECT @startdate,@enddate

SELECT * FROM yourtable
WHERE StartDate BETWEEN @startdate AND enddate

[Back to original message]