Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Calculating someone's age by comparing DOB in a recordset with current date and display it in years and months?

View all replies to this thread

Calculating someone's age by comparing DOB in a recordset with current date and display it in years and months?

Thread began 6/01/2016 2:32 pm by Nathon Jones Web Design | Last modified 7/05/2016 8:15 am by Nathon Jones Web Design | 4947 views | 16 replies

6/02/2016 4:35 pmRay BorduinWebAssist

Is it a varchar column in the database? php will assume european date format if you use dashes instead of slashes I think, so you may be able to use:

php:

<?php

$birthDate = strtotime(str_replace("/","-",$rsPROFILE->getColumnVal("dogsdob")));

$ageInSeconds = time() - $birthDate;

$age = intval($ageInSeconds/(60*60*24*365));

$months = intval((($ageInSeconds/(60*60*24)) % 365)/12);

echo(strval($age) . " years " . $months . " months");

?>

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.