Getting Respondents Age from Dates
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?