Hi,

The latter, the display format of a datetime is as shown.

The column is of Varchar(24) data type.

When I insert the lines you have provided I get the error:

Msg 102, Level 15, State 1, Line 17

Incorrect syntax near '>'.

SELECT

s.TaskID,

t.TaskName,

T.TimeStarted,

s.Action,

s.SourceHost As Source_File_Location,

s.DestFileName As Destination_FileName,

t.Success,

t.LastErrorText

FROM

Stats S

JOIN Taskruns T

ON S.TASKID = T.TASKID

WHERE Success not like 'No xfers'

ANDSuccess like 'Failure'

AND Action not like 'Process'

AND (T.TimeStarted => DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) -- 2010-12-07 00:00:00.000

AND T.TimeStarted < DATEADD(dd, 0, 1 + DATEDIFF(dd, 0, GETDATE()))) -- 2010-12-08 00:00:00.000

ORDER BY T.TimeStarted DESC