DateAdd

Question

Post reply

DateAdd

Mike-238404

Old Hand

Points: 353
More actions
August 29, 2005 at 1:41 pm

#168148

Trying build this some that it will return 24 months from the current day. What am I doing wrong??

SELECT TYPE,vendor,discontinueddate, datepart(quarter,[discontinueddate]) AS 'Quarter'
from EOL
WHERE DISCONTINUEDDATE <DateAdd("M",24,GETDATE())
and (DISCONTINUEDDATE = '01/01/2005')
Order by Discontinueddate

Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

SELECT TYPE,vendor,discontinueddate, datepart(quarter,[discontinueddate]) AS 'Quarter'

from dbo.EOL

WHERE DISCONTINUEDDATE > DateAdd(M,-24,GETDATE())

Order by Discontinueddate

Mike-238404 Old Hand Points: 353 More actions · Answer 2

For some reason that makes it go from 2003 - 2009

I need current day plus 24 months so I can show 8 quarters of info at a time.

Thanks for the help.

Mike

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

SELECT TYPE,vendor,discontinueddate, datepart(quarter,[discontinueddate]) AS 'Quarter'

from dbo.EOL

WHERE DISCONTINUEDDATE > DateAdd(M,-24,GETDATE()) and DISCONTINUEDDATE < DATEADD(D, 1, DATEDIFF(D, 0, GetDate()))

Order by Discontinueddate

SQLBill SSC Guru Points: 51440 More actions · Answer 4

You say it goes from 2003 to 2009.

Run this:

SELECT GETDATE()

That will show you what the server's date is set as. If you are getting 2009, it looks like your system date is off.

Note that Remi's suggestion does NOT have the quotes around the M in the DATEADD function, where yours did. Remi's is the correct way of doing it. If you want 24 months earlier than GETDATE(), use the -24 otherwise make it 24.

-SQLBill

Mike-238404 Old Hand Points: 353 More actions · Answer 5

I thought the same thing but it shows the correct date and time. It's my local PC<G>

Still getting a startdate of 2003 -24 and nothing on 24 or +24

The filed is a smalldatetime on SQL 2000 .

If I do WHERE (DISCONTINUEDDATE >= '01/01/2005') I get 01/01/2005 and up correctly as well.

Thanks for all of the help!!

Mike

sushila SSC-Dedicated Points: 35293 More actions · Answer 6

mike - isn't this the same as what is being discussed on this other thread..?!?!

other thread

**ASCII stupid question, get a stupid ANSI !!!**

Mike-238404 Old Hand Points: 353 More actions · Answer 7

Yes I was asking the same thing. I though I should start a new thread since it was somthing different.

I appologize if it offended someone.

sushila SSC-Dedicated Points: 35293 More actions · Answer 8

Hey Mike - no one's offended! Just double checking to make sure!

**ASCII stupid question, get a stupid ANSI !!!**