Version 2.6
Fixed the Current Age calc:
CASEWHEN( DAYOFYEAR( '2008-' || TO_CHAR( "Birthdate", 'MM' ) || '-' || TO_CHAR( "Birthdate", 'DD' ) ) > DAYOFYEAR( '2008-' || TO_CHAR( CURDATE( ), 'MM' ) || '-' || TO_CHAR( CURDATE( ), 'DD' ) ), YEAR( CURDATE( ) ) - YEAR( "Birthdate" ) -1, YEAR( CURDATE( ) ) - YEAR( "Birthdate" )

2.6 Date: 2010-Jan-12 Size: 114.97 KBVersion 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' ) ) < DAYOFYEAR( '2008-' || TO_CHAR( CURDATE( ), 'MM' ) || '-' || TO_CHAR( CURDATE( ), 'DD' ) ), YEAR( CURDATE( ) ) - YEAR( "Birthdate" ), YEAR( CURDATE( ) ) - YEAR( "Birthdate" ) - 1 )
For more Base functions, just FYI:
http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_P...
http://hsqldb.org/doc/2.0/guide/builtinfunctions-chapt.html
http://hsqldb.sourceforge.net/doc/guide/ch09.html

2.4 Date: 2010-Jan-11 Size: 114.79 KBVersion 2.3
consolidated the two instruction forms into a single form

Version 2.2 -- modified Import Data instruction

Version 2.1 1-1-2009
Minor cosmetic / instructions modification

Version 2.0 1-1-2009
Includes instructions on importing data such as .csv data
Fixed report footer to show date of printing

Version 2.0 1-1-2009
Includes instructions on importing data (such as .csv data)
Fixed report footer to show date of printing

Version 1.0 Dec 29, 2008

|
By any use of this Website, you agree to be bound by these Policies and Terms of Use |