CODEWITHSUNDEEP
sqlsql-server
user5112319
user5112319

Reputation:

how to get records who is reaching todays date

I want to get records who are about reach todays date with in 2 days ProjectEnddt. i want to show Projects who are going to end with in 2 days. want to show 2 days before.

Upvotes: 1

Views: 63

Answers (3)

Ullas
Ullas

Reputation: 11556

Query

SELECT ProjectEndDt
       , ProjectRenewalDt 
       , ProjectUpgradeDt
FROM   tbl_project
WHERE  CONVERT(VARCHAR(10), DATEADD(DAY, 2, ProjectEndDt)) >= CONVERT(VARCHAR(10), GETDATE());

Upvotes: 2

Pawan
Pawan

Reputation: 1744

Try this:

SELECT ProjectEndDt
       ,ProjectRenewalDt 
       ,ProjectUpgradeDt
FROM tbl_project       
WHERE  CAST(ProjectEndDt AS DATE) < CAST(DATEADD(DAY, 3, GETDATE()) AS DATE)

Upvotes: 0

M.Ali
M.Ali

Reputation: 69504

Try this:

SELECT ProjectEndDt
   ,ProjectRenewalDt 
   ,ProjectUpgradeDt
FROM tbl_project
WHERE  CONVERT(DATE,[ProjectEndDt]) < DATEADD(DAY, 3,CONVERT(DATE,GETDATE()))

Upvotes: 0

Related Questions