Thanks!

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

from EOL

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

Order by discontinueddate

works and returns the Current quarter but how do I change the GETDATE to cover all years 2005 and...

Thank You!!! Yes that's the correct way and I missed it to during the creating of the table. Thinking to much. If you have the ONE date that's constant then...

Insert into sunrise (Poc, Sunset, DateBefore, DateAfter) values (@Poc, @Sunset, dateadd(m, -6, Production), dateadd(m, 6, Production))

Server: Msg 137, Level 15, State 2, Line 1

Must declare the variable '@Poc'.

hey I got you to 2K COOL!!!

Yes one field is the one I need to pull the up or down dates from

Production

Thanks

Mike

I m still messed up

Insert into sunrise (Poc, Sunset, DateBefore, DateAfter) values (@Poc, @Sunset, dateadd(m, -6, Datefield), dateadd(m, 6, Datefield))

Simple insert

INSERT INTO tbTest (field1, field2, field3, field4) VALUES ('1', '1', '1',

'1')

Just need to do one bult update on two fields

POC is the 6 months older field

Sunset is the 6 month newer

Sorry I am super new to dealing with dates. ...

Thank you !!! so would it be

insert fieldname dateadd(m, -6, Datefield)