2 Replies Latest reply on Oct 14, 2007 3:06 PM by cf_dev2

    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?