SQLTeam.com | Weblogs | Forums

Identy records that come in 14 days prior to due date


I am trying to right a query that will allow me identify dates that did not arrive 14 days prior to due date.

Arrival_date arrived 13 days or less prior to Planned_date from parts_due table.

FROM   parts_due
WHERE  DATEDIFF(DAY, Arrival_date, Planned_date) <= 13


Thanks allot