Z
zerobug3000
Guest
i need to find the age of a particular person on a table using there date of birth, i know this is probably a simple datediff function thingy but i cant work it out.
Actually got it working now, however using (DateDiff("yyyy",[Date of Birth],Date())) it works but takes ur age from the begining of the year, say you were 20 years old on the 20th May 2003 it says your 20 from the begining of 2003. any one know answer to that?
Actually got it working now, however using (DateDiff("yyyy",[Date of Birth],Date())) it works but takes ur age from the begining of the year, say you were 20 years old on the 20th May 2003 it says your 20 from the begining of 2003. any one know answer to that?
Last edited:
