To late, I already did what the microsoft article recommended. Scary. I have installed developer edition and all is well. It's only a personal laptop, not so much worry. Lesson...

Hi Newbie!

I hope you got your problem resolved from your post from 2004...

Do you remember how you got the SQL Server completed uninstalled? I am running into the same...

Don't forget to check out http://www.tek-tips.com !

Used this function and it does not return errors.

CREATE FUNCTION dbo.f_get_age (@DOB datetime, @toDate datetime)

RETURNS int

AS BEGIN

DECLARE @iReturn int

DECLARE @iYears int

DECLARE @iMonths int...

Have been doing some testing.

Tried the select statement using only the udf and I provided the data:

SELECT DBO.F_GET_AGE(10 aug 1970, GETDATE())

**by the way, no that's not my REAL dob!!:D

The...

Hmm. Thought that would be it also, but no rows returned are null. Since I am new at UDFs is there a way to test the UDF? Can I...

It actually does return data but gives me this error:

Server: Msg 242, Level 16, State 3, Procedure f_get_age, Line 16

The conversion of a char data type to a datetime data...

Thanks for the replies. Here's what I've done:

Per JPIPES recommendations:

1.Changed datetime to smalldatetime - still recieve error.

The conversion of a char data type to a datetime data type resulted...