Age output instead of date in FE

**lostrisq** · 03/26/2010, 17:06

When creating a date field in the catalog, is it possible to have it display the age of a person instead of the date?

**thyon** · 03/31/2010, 08:23

You can use the version 2.0 Alpha and then add a Calculated field, but you'll have to know SQL to be able to write your age calculation from the birthday.

birthdate = 124315315 (let's say its 1969-10-20)
age = (-TIMESTAMPDIFF(YEAR, CURDATE(),DATE(FROM_UNIXTIME(birthdate))))

**lostrisq** · 03/31/2010, 20:19

Thanks! I'll give it a go

**Ben_360fusion** · 04/01/2010, 09:53

Could you use SQL to display the date like this: Monday 1st January 2010?

This would be great for displaying dates in a catalogue i have for some courses.

**Ben_360fusion** · 04/06/2010, 15:14

I was able to turn the Unix time from the catalog date picker to display the date like this: Monday 1st April 2010.

I did this by adding some php to the template

This is the usual echo code:
<?php echo $entry['data']['service_date_date'']['value'];?>

service_date_date being the name of the catlogue field

I changed it to this:
<?php echo date("l jS F Y", $entry['data']['service_date_date']['value']);?>

Other things you can do can be found here: http://php.net/manual/en/function.date.php

I'm not a developer so can't explain more than this. hope someone else finds it useful.

**thyon** · 04/16/2010, 12:09

Hey Ben

Now you're just being silly. The Catalog has always included the ability to format a date. Just enable formatting and then select DATE and then choose the date string. Its automated!