determining age in peoplesoft query

[jazdwit07]

hi, is there an expression i can use in peoplesoft query to return the
exact age of person using the Birthdate field? thanks.

 

[John Vinson]

hi, is there an expression i can use in peoplesoft query to return the
exact age of person using the Birthdate field? thanks.

Are you using Microsoft Access (the subject of this newsgroup) to link
to data stored in PeopleSoft? If not, you would do much better to ask
your question in a forum which supports the software you are using.

If you ARE using Access, put a calculated field in your query:

Age: DateDiff("yyyy", [Birthdate], Date()) - IIF(Format([Birthdate],
"mmdd") > Format(Date(), "mmdd"), 1, 0)

John W. Vinson[MVP]

 

[Rick B]

Not sure about peoplesoft, but the formula to calculate age in an ACCESS
query (the topic of this newsgroup) is:

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(),"mmdd"))

 

[jazdwit07]

Not sure about peoplesoft, but the formula to calculate age in an ACCESS
query (the topic of this newsgroup) is:

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(),"mmdd"))


--
Rick B

hi, is there an expression i can use in peoplesoft query to return the
exact age of person using the Birthdate field? thanks.

sorry, wrong group. Thanks for the info, however. It will help for
access as well.