Birthday Date Calculation 1

[AnnieRider]

Hi

Is there a way to calculate the date that someone will turn 20 using their DOB? I want to do this in a view that I will then write my report on.
I've tried playing around with DateDiff but cannot seem to get a working solution.

Many Thanks
Annie

 

[RiverGuy]

Try this. Swap out the variable for your table's column

DECLARE @PersonsBDay DATETIME
SELECT @PersonsBDay = '19900225'

SELECT DATEADD(year, 20, @PersonsBDay) AS DatePersonTurnsTwenty

 

[AnnieRider]

Hi

That's great thank you very much.

Annie )