SQLTeam.com | Weblogs | Forums

Identy records that come in 14 days prior to due date


#1

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.


#2
SELECT *
FROM   parts_due
WHERE  DATEDIFF(DAY, Arrival_date, Planned_date) <= 13

#3

Thanks allot