Hi,

I have spent some time trying to do the following, with limited success. Hopefully there is an easier way.

As part of a model I have created I run through a group of respondents for x amount of years

For each respondent I want to pick up their DOB from a datatable, and then using a StartDate, or current date work out the models age (rounded down)

i.e. DOB (from Table) = Dec 13th 1975
     Startdate = Now (July 3rd 2007)
     so age would be 31

My question is how what is the code for this, from Public or Dim to getting the answer of 31?

Any ideas?

JP



JP.

A Google search on the subject returns many examples. Here is one:

http://www.freevbcode.com/ShowCode.asp?ID=4462





Best Regards,
Earl Francis