Recently Written- Lion, iCloud, and Bento… October 25, 2011
- Bento 4.06 Available October 1, 2011
- Bento Price Drop Confirmed! August 23, 2011
- Bento 4.0.5 Available! August 9, 2011
- It’s Confirmed: Lion Is Fighting Bento! August 1, 2011
- Bento 4.0.3 Update Is Unstable May 21, 2011
- Customizing Themes Even Further April 23, 2011
- Sorely Needed: Page Guides On Forms! April 23, 2011
- List Field Refinements Needed April 12, 2011
- Dear Filemaker & Bento Product Manager: April 11, 2011
- New Free Service: iChat Screen-Sharing! April 10, 2011
- Bento 4 Crashes Reach BentoUsers! March 17, 2011
- Finally: Bento 4 – First Review! March 16, 2011
- Bento Black-Friday Pricing! November 26, 2010
- Important Software Update – Bento 3.0.5 November 4, 2010
Mar
26
Calculating Ages
Filed Under Bento Tips | 18 Comments
It is fairly simple to add a field to a Library which will show you someone’s age. You need to add a Calculation field to your Library and set the formula to be:
Addendum
If you are using Bento 3 or 4 (and presumably other future versions) you can use an undocumented math function to simplify the calculation. If you edit the formula to read ‘Floor( ([Today] – [Birthday]) / (60 * 60 * 24 * 365.25) )’ then Bento will round the age down. Essentially you can remove the ‘- 0.5′ element. Note that there must not be a space between the word Floor and the opening bracket.
