I have table "merit.dbf" having field with 1. Regno 2. Name 3. Caste 4. dob 5. Age
The data type of dob field is Character type. I want to calculate age for each student and put in the age field.

The table look like below

Regno Name caste dob age
30001 S. sakthi GE 01/08/1994
30002 K. Karthi GE 15/07/1994
30003 N. Kumar GE 25/09/1995
30004 R. Mano SC 10/03/1994
30005 L. Kavi SC 09/05/1995

How to calculate age and put in age field?