SQL Date question

Hi,

I have the follwing sql, the problem is that I am trying to bring up all
records which date is equal to getdate().

The problem seems to be that the "date" which is a timedate field compares
getdate and the time too, do I dont get any matches. How can I compare the
dates only ?

SQL:

Select

a.Id, a.CaseId, a.AlienId, b.UserId, b.FirstNm,
b.LastNm,a.Process,a.Processstep,c.ProcesscatalogI d,c.Processcatalog,d.Proce
ssstepId,d.Processtep, d.TimeFrame, d.EmailAlert, a.Processdateupdate,
DATEADD(day,d.Timeframe , a.Processdateupdate ) AS Datedue

from cases as a
LEFT JOIN Users b ON a.AlienID = b.UserID
INNER JOIN Processcatalog c ON a.Process = c.ProcesscatalogID
INNER JOIN Processstep d ON a.Processstep = d.ProcessstepId
INNER JOIN atts e on a.id = e.caseid

WHERE a.Firmid = 2 AND (DATEADD(day,d.Timeframe,a.Processdateupdate ) =
getdate())


Help Appreciated,

Z

Use datediff. eg

select * from t where datediff(d,datefield,getdate())=0

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Excelent, this worked:

datediff(d,(DATEADD(day,d.Timeframe,a.Processdateu pdate)),getdate())=0

Thanks !!!

Z



"Julian Roberts" <newsg (AT) charon (DOT) co.uk> wrote

Use datediff. eg

select * from t where datediff(d,datefield,getdate())=0

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004