Family Address Book with Birthday Reminders-2.4

Extension:
Extension ID:
Release date:
11/01/2010 - 14:34
Version:
2.4
Operating system:
System Independent
Compatibility:
3.4
Binary type:
OOo extension (.oxt)
Release Notes: 

Version 2.4 adds 1) a new "All Data" report to include Notes, 2) minor cosmetic changes, and 3) a correction of the Age calculation in the Family Information report.

Note: this coding doesn't work to determine age:
DATEDIFF( 'yy', "Birthdate", CURDATE( ) )

Instead, I had to use this coding:
CASEWHEN( DAYOFYEAR( '2008-' || TO_CHAR( "Birthdate", 'MM' ) || '-' || TO_CHAR( "Birthdate", 'DD' ) )

For more Base functions, just FYI:
http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures
http://hsqldb.org/doc/2.0/guide/builtinfunctions-chapt.html
http://hsqldb.sourceforge.net/doc/guide/ch09.html