This function is used to calculate the age from the given date.
Regards,
Vignesh Arulmani
This function is used to calculate the age from the given date.
Regards,
Vignesh Arulmani
create function [dbo].[fn_calc_age] (@dob datetime) returns varchar(64) as begin declare @age int declare @getdate datetime = getdate() if @dob >= @getdate return 'Invalid Input' set @age = datediff(yy, @dob, @getdate) if month(@dob) > month(@getdate) or (month(@dob) = month(@getdate) and day(@dob) > day(@getdate)) set @age = @age - 1 return convert(varchar,@age) + ' Years and ' + convert(varchar,datediff(dd,dateadd(yy,@age,@dob),@getdate)) + ' Days' end go