determining age in peoplesoft query

  • Thread starter Thread starter jazdwit07
  • Start date Start date
J

jazdwit07

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

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]
 
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 said:
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.
Click to expand...
Click to expand...
sorry, wrong group. Thanks for the info, however. It will help for
access as well.
 
Back
Top