E
Emma
Can somebody help me with the code for a persons age based on a date given?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
fredg
On a Date Given? Given how? Stored in a field on a table?Can somebody help me with the code for a persons age based on a date given?
In a query:
Age: DateDiff("yyyy",[DOB],[DateGiven])-IIf(Format([DOB],
"mmdd")>Format([DateGiven],"mmdd"),1,0)
Directly as the control source of an unbound control:
=DateDiff("yyyy",[DOB],[DateGiven])-IIf(Format([DOB],
"mmdd")>Format([DateGiven],"mmdd"),1,0)
Where [DOB] is the birthdate field and [DateGiven] contains the date
to compute the age to.
As of the current date?
In a query:
Age: DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],
"mmdd")>Format(Date(),"mmdd"),1,0)
Directly as the control source of an unbound control:
=DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],
"mmdd")>Format(Date(),"mmdd"),1,0)
You do know, I hope, that this Age computation should NOT be stored
in any table. Just compute it and display it on a form or report, as
needed.
E
Emma
Thanks Fred works great!
fredg said:On a Date Given? Given how? Stored in a field on a table?Can somebody help me with the code for a persons age based on a date given?
In a query:
Age: DateDiff("yyyy",[DOB],[DateGiven])-IIf(Format([DOB],
"mmdd")>Format([DateGiven],"mmdd"),1,0)
Directly as the control source of an unbound control:
=DateDiff("yyyy",[DOB],[DateGiven])-IIf(Format([DOB],
"mmdd")>Format([DateGiven],"mmdd"),1,0)
Where [DOB] is the birthdate field and [DateGiven] contains the date
to compute the age to.
As of the current date?
In a query:
Age: DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],
"mmdd")>Format(Date(),"mmdd"),1,0)
Directly as the control source of an unbound control:
=DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],
"mmdd")>Format(Date(),"mmdd"),1,0)
You do know, I hope, that this Age computation should NOT be stored
in any table. Just compute it and display it on a form or report, as
needed.