There is only One row

Discontinueddate

with dates from 01/01/1983 - 01/01/2099

From this I can get Which quarter 1-4 there are in

and create and populate a quarter field

I am trying to...

I need to take one date and break it down into quarter with years so I can do a two year look ahead. 8 quarter vs the 4 I am doing...

Sure. It's at 0 here but I change it to -6 or six months before the discontinueddate as of today. All software expiring withing six months is flagged and a...

Your are correct. I should be more specific and I appreciate you pointing that out. Here is what I did to possibly fix it.

NEW 

SELECT CATEGORY, TYPE, VENDOR, VENDORID, PRODUCT, DISCONTINUEDDATE,...

Since in my particular job I cannot "JUST" send the data, I have to make sure there is nothing referenced to the company I work for. Big no no. So I...

INSERT INTO [youdatabase].[dbo].[EOL]([ID], [TYPE], [CATEGORY], [PRODUCTID], [PRODUCT], [VENDORID], [VENDOR], [VERSIONID], [VERSION], [DESCRIPTION], [PLATFORM], [GLOBALRECOMMENDATION], [LOCALRECOMMENDATION], [SUPPORTED], [SUPPORTGROUP], [ESTIMATEDCOST], [LICENSESCHEME], [OBTAINCHANNEL], [BUDGETCODE], [PRODUCTPUBLISH], [VERSIONPUBLISH], [DISCONTINUEDDATE], [Sunset], [GTPM], [COMPOUND], [CREATEDDATE], [REQUESTSTATUS], [PRODUCTLASTUPDATEDATE],...

one at a time<G>

CREATE TABLE [EOL] (

 [ID] [int] NOT NULL ,

 [TYPE] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [CATEGORY] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [PRODUCTID] [varchar] (53) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [PRODUCT] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS...

ORDER BY CONVERT (DATETIME, DISCONTINUEDDATE) still mixs up the dates

all of the date fields are datetime 8

I rechecked all of the fields and I do not have anything other than ...

SELECT Type, Vendor, discontinueddate, DATEPART( YEAR, discontinueddate) AS 'Quarter Year',datepart(quarter,[discontinueddate]) AS 'Quarter'

FROM EOL  

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

Order by Discontinueddate

Seems to work ok here.

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.

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...

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...

what if I need the quarters always 24 months from today everyday?

I tried using the DateAdd("m",24,Now());

But no luck

Hints??

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

from EOL

WHERE (DISCONTINUEDDATE >= '01/01/2005')

Order by Discontinueddate

Works!!!