Calculate age using Omniform 5.0

Discussion in 'Business Applications' started by bot24, Sep 24, 2008.

Not open for further replies.
1. Hello,

I am working on developing a new reporting form. I have developed the form using Omniform 5.0 and I would like the form to calculate a persons current age automatically.

I beleive I am using the right formula: Sum([Date]-[Date of Birth])/365.25

Here lies my problem:
So, today's date 9/24/2008 - 2/23/1977 = 31.58
If I change the settings to only use two decimals omniform returns the age as 32. Is there any way to make it use two decimals yet not round the answer? Will it round down?

If I keep the settings at two decimals I am able to delete the .58 and have it say 31.00; however, this isn't quite the look I was hoping for in the end product.

Any help would be much appreciated.

2. here is something someone tried to find out how old someone is based on two dates
Age Formula:
Create the following fields:
dob
dod
age year
age month
age month year
age day
cut and paste the following formulas

dob - (must be date field)
dod - (Must be date field)
age year - (Year([dod]))-(Year([dob]))
age month - If(Month([dod]) < Month([dob]),[age year]-1,[age year])
age month year - If(Month([dob])=Month([dod]),"month equal","")
age day - If([age month year]="month equal" And DayOfMonth([dod]) < DayOfMonth([dob]),[age month]-1,[age month]-0)
Let me know how it goes