Date diff issue

[KeithLaw999]

Hi i have a delete function using MS SQL.

DELETE FROM TABLE
WHERE DATEDIFF(d, InDate, GETDATE()) >= 28

this should delete any entries that are 28 days old, but "InDate" is a datetime stamp and the delete fuction is actually deleting rows that i enter taday.

any ideas why?

[cf_dev2]

> this should delete any entries that are 28 days old

28 days or older, from the date and time now.

> WHERE DATEDIFF(d, InDate, GETDATE()) >= 28
> any ideas why?

I don't see how that's possible unless perhaps InDate is not a datetime column or the value in the InDate column is not what you think it is.