| Extension:  | |
| Extension ID:  | |
| Release date:  | 11/01/2010 - 14:34 | 
| Version:  | 2.4 | 
| System Independent | |
| Compatibility:  | 3.4 | 
| Binary type:  | OOo extension (.oxt) | 
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