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
RobOn Jun 19, 4:21 pm, roblowein <rob.low...@.gmail.comwrote:
Quote:
Originally Posted by
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|||Hello, Rob
Try something like this:
SELECT * FROM YourTable
WHERE DATEPART(hh,StartDate) BETWEEN 8 AND 18
AND (DATEPART(w,StartDate)+@.@.DATEFIRST)%7 BETWEEN 2 AND 6
Razvan|||On 19 Jun, 12:56, Razvan Socol <rso...@.gmail.comwrote:
Quote:
Originally Posted by
Hello, Rob
>
Try something like this:
>
SELECT * FROM YourTable
WHERE DATEPART(hh,StartDate) BETWEEN 8 AND 18
AND (DATEPART(w,StartDate)+@.@.DATEFIRST)%7 BETWEEN 2 AND 6
>
Razvan
Thanks to you both...
A lot of help..
Regards
Rob
