Erweiterung: |
|
Extension ID: |
|
Release date: |
11/01/2010 - 18:17 |
Version: |
2.6 |
System Independent |
|
Compatibility: |
3.4 |
Binary type: |
OOo extension (.oxt) |
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" )