Hi Chris, well that works for bring that date I added my part to the top

SELECT * from SLADB.dbo.ProdDataTB

where MachineName = ('APS01')

Select

d.StartDate_Time,

date_string = p.[Year]+'-'+p.MonthNum+'-'+p.[Day]+' '+p.[Time],

date_datetime = CONVERT(DATETIME,p.[Year]+'-'+p.MonthNum+'-'+p.[Day]+' '+p.[Time],120)

FROM (SELECT StartDate_Time = 'Wed Sep 01 03:00:00 2010') d

CROSS APPLY (

SELECT

[Year] = RIGHT(d.StartDate_Time,4),

x.MonthNum,

[Day] = SUBSTRING(d.StartDate_Time,9,2),

[Time] = SUBSTRING(d.StartDate_Time,12,8)

FROM (VALUES ('01','Jan'),('02','Feb'),('03','Mar'),('04','Apr'),('05','May'),('06','Jun'),

('07','Jul'),('08','Aug'),('09','Sep'),('10','Oct'),('11','Nov'),('12','Dec')) x (MonthNum, MonthName)

WHERE MonthName = SUBSTRING(d.StartDate_Time,5,3)

) p

How do I get everything for that day given the fact that a job could start at 23:00 and finish at 01:00 ht next day which the above query would include.

So the start should be from for example

StartDate_Time 06/06/2012 00:00

EndDate_Time 06/06/2212 23:59

everything between these these dates inc hours ?

Does this make sense?