Select rows where due in 15 days

Question

question

technette asked Mar 6, '14

Select rows where due in 15 days

I need to select all rows where estimates are due in fifteen days from the given quote date. How do I do this?

dateadd

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2014-03-06T01:59:28Z

Squirrel answered Mar 6, '14

SELECT * FROM yourtable WHERE estimate_date

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

technette commented · Mar 06, 2014 at 07:44 PM

Thank you. I did a slight modification: Select DATEADD(DAY, 15, QuoteDate) As DueDate Then I gave a report with all quotes created in the past 30 days which showed the DueDate.

0 ·

Answer 2 · 2014-03-06T02:38:06Z

DenisT answered Mar 6, '14

DECLARE @T1 TABLE ( Id INT NOT NULL , EstDate DATE NOT NULL ); INSERT INTO @T1 VALUES ( 1, DATEADD(DAY, -1, GETDATE()) ), ( 2, DATEADD(DAY, 15, GETDATE()) ), ( 3, DATEADD(DAY, 15, GETDATE()) ), ( 4, DATEADD(DAY, 14, GETDATE()) ), ( 5, DATEADD(DAY, 14, GETDATE()) ), ( 6, DATEADD(DAY, 16, GETDATE()) ), ( 7, DATEADD(DAY, 16, GETDATE()) ), ( 8, GETDATE() ); SELECT * FROM @T1 t; SELECT * , CAST(GETDATE() AS DATE) AS [QuoteDate] , CAST(DATEADD(DAY, 15, GETDATE()) AS DATE) AS [QuoteDate+15] FROM @T1 t WHERE t.EstDate >= CAST(GETDATE() AS DATE) AND t.EstDate

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question