I am using an Access database with 3 fields: title, date, and news. I set the "date" field to be of "date/time" type, and "short date" format. The cells are populated with records such as 8/11/2000, etc.<BR>This is the SELECT statement I&#039m using:<BR><BR>TodayMinus4 = DateAdd("d", -4, date)<BR>strSQL = "SELECT * FROM tblNews WHERE date &#062;= " & TodayMinus4 & " ORDER BY date DESC"<BR><BR>I want to display the news for only the last 4 days, but for some reason it is returning every record on the database rather than just the last four days... what could be wrong?