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.
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.
SELECT *
FROM parts_due
WHERE DATEDIFF(DAY, Arrival_date, Planned_date) <= 13
Thanks allot