I am having calculating current age because the birthdays are saved in that format.
I am having calculating current age because the birthdays are saved in that format.
Use DateSerial() to change it to a date with string functions (Left, Mid, Right).
convert to a real date
vDat = mid([field],5,2) & "/" & mid([field],7,2) & "/" & left([field],4)
vAge = DateDiff("yyyy",vDat,Date())
Thank ranman, problem solved.
I notice that the date is not accounted for in the calculations. So someone who was born 11/30 given today is 11/11 is round off, is there way to get date into the calculations?