I need to ascertain the date difference using a flowing query but it
does not work. Please Guide.
SELECT ID, VoucherNo, DateRec, ProductID, Description, ClaimantCo, ClaimantName, City, Phone, DateReturn, ReqJob, WSIns, Remarks, Status, Part1, Part2, Part3, Part4, OtherWSCharges, FDCharges, P1Charges, P2Charges, P3Charges, P4Charges, DateJobBegun, DateJobDone, WSRemarks, TotChargesFromWS, DeliveryStatus, DateDelivered
FROM tblClaims
WHERE DateDiff(dd, DateReturn, GETDATE()) =3
Before trying this I have also gone through some resources here
but was not sure what I am doing is correct is not, My motivation is
to get records for which three days are passed on to DateRetun,
contrasting with the present date.
