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