'works out the age of the apprentice.

Dim total As String

Dim strDOB As String = Format(CDate(.DateOfBirth), "MM dd")

...

Sergio Lugo (6/30/2008)

---

Hi everyone !

I use this formula:

Age = floor(datediff(day, [DateOfBirth], getdate())/(365.25))

You can also put it in a calculated column.

It works (I think) because one year actually has 365.25 days......

hi.

i'm getting this error and i've added the SET FMTONLY OFF section as well.

here's the code that i'm running in SQL Query Analyzer:

select * from openquery ( [SEVERNAME] , '...

i used the "..." because mysql tables dont seem to have an 'owner'. e.g: dbo.

so since we've only got the one database on that server then "..." seems to work...

i'm trying to do an insert statement aswell. its going to a mysql linkserver database. the linked server is on an sql server.

the link server is using the mySQL...