getDate() + 1 year 1

[mcb999]

Whats the best way of setting a date field to add 1 year from the current date?

Using getDate() set the current date by default so I would imagine its just a matter of adding something between the brackets.

Thanks

 

[monksnake]

Select dateadd(yy, 1, getdate())

<.

 

[Jamfool]

SELECT DATEADD(yy,1,GETDATE())

 

[mcb999]

perfect..thanks!

 

[monksnake]

<.