Hi, All, Anybody know how to get

[Guest_imported]

Hi, All,

Anybody know how to get "date" around year?
Example: date1(07/02/01). I want to create field "DeadLine(07/02/02)". Would you please tell me how to write stored proceure to get field "DeadLine" depend on "date1"?

 

[tomjscribe]

the DATEADD function will work


select DATEADD(yy,1,"07/02/01&quot

returns

---------------------------
2002-07-02 00:00:00.000

(1 row(s) affect

 

[rajeevnandanmishra]

Hi there,
Try to use following snippet.
------------------------------
CREATE PROCEDURE myProc
(@myDate DATETIME=getdate(), @retString VARCHAR(50) OUTPUT)
AS
SELECT @retString="DeadLine ("+
convert(char(10),dateadd(yy,1,getdate()),101)+&quot"
------------------------------

If you find any problem let use know.