2. PHPRunner General questions
  3. [SOLVED]  Calculating Date of birth
This topic is locked
[SOLVED]

 Calculating Date of birth

 		8/2/2014 1:20:45 PM
PHPRunner General questions
J
 jasongreenwood author

Hi there,
I'm struggling to find out how to calculate a date of birth into an age field so I can run specific reports on the age?
I've got dob and age tables but am unsure how I can calculate the dob to show the age?
Any help would be mostly appreciated.
Kind regards
Jason
romaldus 8/2/2014



Hi there,
I'm struggling to find out how to calculate a date of birth into an age field so I can run specific reports on the age?
I've got dob and age tables but am unsure how I can calculate the dob to show the age?
Any help would be mostly appreciated.
Kind regards
Jason


read this for inspiration:

http://ma.tt/2003/12...e-age-in-mysql/
or this one:

http://blog.ubiq.co/age-from-date/
J
 		jasongreenwood author 8/2/2014



read this for inspiration:

http://ma.tt/2003/12...e-age-in-mysql/
or this one:

http://blog.ubiq.co/age-from-date/


Thanks for these it's much appreciated. However, I'm having the problem of where to insert these commands in PHP Runner? Is it on Load or is it in SQL?
Sorry for all the questions.
Jason