Posted by roblowein on 06/19/07 11:21

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

• Next in forum: Re: DateTime
• Prev in forum: Re: mdac 2.8 and sql 2005 cursor performace issue
• Thread view: DateTime

[Reply to this message]