Calculating date difference in SQL query

Question

0.00/5 (No votes)

See more:

I need to calculate date difference using flowing query but it does not work. Please advise.

SQL

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

My purpose is to get records for which three days are left to DateRetun, comparing to today's date.

Thanks

Posted 14-Feb-12 23:53pm

Furqan Sehgal

Updated 14-Feb-12 23:54pm

CRDave1988

v2

Add a Solution

Comments

Simon_Whale 15-Feb-12 5:26am

In what way doesn't it work? no results? wrong results?

How is the DateReturn setup?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-02-15T00:28:00

Try reversing the order:

SQL

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, GETDATE(), DateReturn) =3

Your way returns when it is 3 days overdue...

Maciej Los · Answer 2 · 2012-02-15T07:55:00

Solution 2

First of all, take a look here[^] and here[^]

SQL

SELECT [ID], GETDATE() AS [ThisDay], [DateReturn], CONVERT(INT, GETDATE() - [DateReturn]) AS [DayDifference]
WHERE DATEDIFF(day, [DateReturn],GETDATE()) =3
ORDER BY [ID]

Posted 15-Feb-12 7:55am

Maciej Los

Calculating date difference in SQL query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Calculating date difference in SQL query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us